Hi
There is something nice in PL-SQL Developer, which is the possibility to drag table name from browser window into any program unit editor, and choose from displayed menu what do you want to drop (for example: Name, Select Into, Insert). On other hand, you can select many columns from browser window, rigth click on them, and select "Copy comma seperated".
All that is nice, but I have a problem: I have a big table (too many columns) that I want to write an insert statement for it, I can drag the table name into program unit editor and select "Insert into" from the pop up menu. The inserted statement look like this:
insert into table_name(col1,col2,...) values (v_val1, v_val2...);
The problem is I have to declare all these "v_val" variables in the declaration section of current program unit. I wonder if there is a way to simulate "Copy comma seperated" column list to one like "Copy semi colon seperated" list of columns and their types that I can easily paste it into declaration section.
thanks
There is something nice in PL-SQL Developer, which is the possibility to drag table name from browser window into any program unit editor, and choose from displayed menu what do you want to drop (for example: Name, Select Into, Insert). On other hand, you can select many columns from browser window, rigth click on them, and select "Copy comma seperated".
All that is nice, but I have a problem: I have a big table (too many columns) that I want to write an insert statement for it, I can drag the table name into program unit editor and select "Insert into" from the pop up menu. The inserted statement look like this:
insert into table_name(col1,col2,...) values (v_val1, v_val2...);
The problem is I have to declare all these "v_val" variables in the declaration section of current program unit. I wonder if there is a way to simulate "Copy comma seperated" column list to one like "Copy semi colon seperated" list of columns and their types that I can easily paste it into declaration section.
thanks
