Hot key for columns

[Dean Lamper]

Is there a quick key, that would insert all columns of the 'current' table, i.e. a table that is written on the left side of the cursor?.

For example, when writing insert clause, I would write INSERT INTO sch.SOME_TABLE and then press a hot key and (COL_1, COL_2, COL_3) would appear aside the table name. It would quite ease up writing querries.

 

[Marco Kalter]

There is no key or function for this. The Code Assistant will show you the column names after typing a comma though. Furthermore you can drag & drop a table from the Object Browser into an Editor and select "Insert" from the popup menu to create a complete insert statement.