Automatically inserting column names for table in TOAD for Oracle

I am looking for a way to automatically insert column na开发者_Go百科mes 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?

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.

select column_name || ','
from all_tab_columns
where table_name = 'SOME_TABLE'
and owner = 'SOME_OWNER'
order by column_id;

The right click on output of field names in data grid and select Export Data (to clipboard as tab delimited, don't include quoting or column headers).

Now copy/paste where u need it. Nice thing is that you can:

1. Use this SQL in any IDE, not just Toad
2. Modify output if needed, as I do in triggers to add ':old' or ':new' prefixes to each field for example, or change order.

It is also possible to generate the statement from the schema browser-> columns tab

Select the columns you want, then right click and select the 'generate statement' menu item,then select the command you want to generate (Select/Insert/Delete).

The script then gets copied to clipboard, for you to paste at your leisure.