How often do we have to write an insert with explicit column list:
May be because the source we are inserting from do not have all the columns.
Or the destination table has that dreaded long column that you have to exclude.
Keep below SQL handy (Oracle database 11g onwards only). To quickly get a comma seperated list of columns for a table.
SELECT LISTAGG(column_name , ',') WITHIN GROUP (ORDER BY column_id ) column_list FROM all_Tab_columns where table_name = upper(:TABLE_NAME) and owner = upper(:OWNER) GROUP BY table_name;
Comments
Post a Comment
Please leave your relevant comments and questions only.