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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!Donate Us With