Home » SQL & PL/SQL » Client Tools » Select * from (windows 7 )
Select * from [message #603104] Wed, 11 December 2013 07:54 Go to next message
karthik7narla
Messages: 9
Registered: December 2013
Location: hyderabad
Junior Member
hello every one ,

instead of typing every time "for example :select * from "
do we have any shortcuts in TOAD so that we will get the statements that which we use most frequently.

i mean not only (select * from) there may be some other statements which we use more frequently .
Re: Select * from [message #603106 is a reply to message #603104] Wed, 11 December 2013 08:07 Go to previous messageGo to next message
BlackSwan
Messages: 22837
Registered: January 2009
Senior Member
is COPY & PASTE broken for you?

Re: Select * from [message #603113 is a reply to message #603106] Wed, 11 December 2013 08:32 Go to previous messageGo to next message
pablolee
Messages: 2633
Registered: May 2007
Location: Scotland
Senior Member
BlackSwan, I have a feeling that the OP is maybe talking about a Toad equivalent to SQL Developer's 'Snippets'. And copy paste isn't much use if the code that you want to use isn't already on your screen (unless you keep a file of your common code and C&P from that...)
Re: Select * from [message #603114 is a reply to message #603106] Wed, 11 December 2013 08:36 Go to previous messageGo to next message
martijn
Messages: 278
Registered: December 2006
Location: Netherlands
Senior Member
BlackSwan wrote on Wed, 11 December 2013 15:07
is COPY & PASTE broken for you?


Isn't that a bit harsh?

A lot of IDE's provide shortcuts for the most commonly used expressions
(in netbeans for instance I save a lot of time by typing "sout <tab>" which is expanded to system.out.println()Wink

I'm not familiar with toad, but I can see where the question is coming from.
Re: Select * from [message #603117 is a reply to message #603104] Wed, 11 December 2013 08:49 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2403
Registered: May 2013
Location: World Wide on the Web
Senior Member
karthik7narla wrote on Wed, 11 December 2013 19:24
instead of typing every time "for example :select * from "
do we have any shortcuts in TOAD so that we will get the statements that which we use most frequently.


This is a TOAD question. And I am very sure that TOAD has options for creating your own shortcuts, it works like autofill. Assign SEL as "SELECT * FROM ". Google a bit or visit TOAD forum and get your answer.
Re: Select * from [message #603237 is a reply to message #603117] Thu, 12 December 2013 08:07 Go to previous messageGo to next message
karthik7narla
Messages: 9
Registered: December 2013
Location: hyderabad
Junior Member
At last i got the answer from google Smile
open TOAD

View->Toad Options.
Editor/behaviour
Click Code Templates button.

Click ADD button.

Set shortcut name = sel
Set Description = Anything you like.
Click OK.

In the middle pane of the main dialoge, enter the text:

select * from |

Note the pipe character, this is where the carat will be placed when you
execute this macro.

Click ok until you are back in the editor.

Type in sel and press CTRL+SPACE. Sel will be replaced by "select * from
" and the cursor is waiting for you at the end, to type in the
tablename.


thank u very much Lalit Kumar B sir and martin Smile
Re: Select * from [message #603261 is a reply to message #603237] Thu, 12 December 2013 12:17 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2403
Registered: May 2013
Location: World Wide on the Web
Senior Member
Thanks for the feedback.
And the point still hold true that it's a question related to TOAD forum Smile
Re: Select * from [message #603266 is a reply to message #603261] Thu, 12 December 2013 14:30 Go to previous messageGo to next message
Littlefoot
Messages: 19646
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I disagree. Forum description says:OraFAQ

Tools for executing SQL and PL/SQL commands: SQL*Plus, iSQL*Plus, SQL Developer and SQL Worksheet. Including 3rd party tools like TOAD, DB Artisan, SQL Navigator, PL/SQL Developer, etc.
Re: Select * from [message #605843 is a reply to message #603266] Wed, 15 January 2014 04:33 Go to previous messageGo to next message
KimberlyDeborah
Messages: 15
Registered: December 2013
Location: United States
Junior Member
This is important for selecting any row ,column ,database or any other important query update,delete,move.
Re: Select * from [message #605845 is a reply to message #605843] Wed, 15 January 2014 04:38 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2403
Registered: May 2013
Location: World Wide on the Web
Senior Member
KimberlyDeborah wrote on Wed, 15 January 2014 16:03
This is important for selecting any row ,column ,database or any other important query update,delete,move.


Is this a question? Well, doesn't seem to be. And what do you mean by the things which I have highlighted in Bold Italics.
Re: Select * from [message #605917 is a reply to message #605845] Thu, 16 January 2014 04:45 Go to previous messageGo to next message
KimberlyDeborah
Messages: 15
Registered: December 2013
Location: United States
Junior Member
Database means : SQL

move : Query for moving data from database into another table or row.
Re: Select * from [message #605919 is a reply to message #605917] Thu, 16 January 2014 05:02 Go to previous messageGo to next message
pablolee
Messages: 2633
Registered: May 2007
Location: Scotland
Senior Member
KimberlyDeborah wrote on Thu, 16 January 2014 10:45
Database means : SQL
No it doesn't. At least it shouldn't

Quote:
move : Query for moving data from database into another table or row.

This makes zero sense.
Re: Select * from [message #605928 is a reply to message #605917] Thu, 16 January 2014 05:57 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2403
Registered: May 2013
Location: World Wide on the Web
Senior Member
KimberlyDeborah wrote on Thu, 16 January 2014 16:15
Database means : SQL

move : Query for moving data from database into another table or row.


You seriously need to look at Oracle® Database Concepts
Re: Select * from [message #605997 is a reply to message #605928] Fri, 17 January 2014 04:53 Go to previous messageGo to next message
KimberlyDeborah
Messages: 15
Registered: December 2013
Location: United States
Junior Member
Ok Thanks.But i have cleared my point to you!!
Re: Select * from [message #606000 is a reply to message #605997] Fri, 17 January 2014 05:04 Go to previous messageGo to next message
Littlefoot
Messages: 19646
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
KimberlyDeborah, as this is an Oracle forum, how much do you know about Oracle? Try to rank your current knowledge from 0 (zero knowledge) to 10 (expert). Also, specify Oracle areas (SQL, Forms, Apex, Administration, ...) you are familiar with.

[Updated on: Fri, 17 January 2014 05:05]

Report message to a moderator

Re: Select * from [message #606015 is a reply to message #605997] Fri, 17 January 2014 07:20 Go to previous message
pablolee
Messages: 2633
Registered: May 2007
Location: Scotland
Senior Member
KimberlyDeborah wrote on Fri, 17 January 2014 10:53
Ok Thanks.But i have cleared my point to you!!

No, no you haven't.
Previous Topic: Select query returns different characters on different desktops, same pl/sql developer versions
Next Topic: How to capture Error Code in sqlplus
Goto Forum:
  


Current Time: Tue Sep 30 01:18:22 CDT 2014

Total time taken to generate the page: 0.23928 seconds