Can you cut, paste, copy a block of text in PL/SQL Developer?
Posted on 2008-10-31
I have been using TextPad to put together SQL statements by using the cut, copy and pasting of BLOCKS of text.
I copy the describe of a table, replace varchar, number, date will 10 spaces and then copy the column names in a block and paste it further down the TextPad.
Then I join the lines into one string, replace the spaces with commas
Then I insert in front of the column name the INSERT INTO table_name(
Then I get the values by copying from somewhere else and paste then in block text where they need to go. ETC, ETC.
I haven't seen how I could do that in PL/SQL Developer.... ???