Logo Questions Linux Laravel Mysql Ubuntu Git Menu

Automatically inserting column names for table in TOAD for Oracle

I am looking for a way to automatically insert column names in TOAD for Oracle to make it easier for writing queries.

Ideally, I would like to type something like the following:

select * from myTable;

Then, when I right-click on *, I would have the option to insert all known column names for that table.

Is it possible in Toad?

like image 563
Jeffrey Kevin Pry Avatar asked Dec 13 '22 11:12

Jeffrey Kevin Pry

1 Answers

Press F4 on that the selected table name, and in the schema browser, select the Columns tab, then select all columns. Then drag the selection, do not copy&paste, back into the editor, and you have your comma separated column names.

like image 71
Erkan Haspulat Avatar answered Jan 05 '23 01:01

Erkan Haspulat