Can you cut, paste, copy a block of text in PL/SQL Developer?

I have been using TextPad to put together SQL statements by using the cut, copy and pasting of BLOCKS of text.
Example:
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.... ???
Thanks, Bill
LVL 2
BILL CarlisleAPEX DeveloperAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (125)

Computer101
EE Admin
0
 
omgangIT ManagerCommented:
Perhaps I am not understanding what it is your doing but I selected a table, chose View, then selected the Columns tab.
I copied all and pasted into a new SQL window.  From there it's simply a matter of editing the text.

OM Gang
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Yes, what I was looking for was the "BLOCK" cut, copy or paste.

I would do as you say and then just cut or copy the columns out of the DDL (minus the datatypes etc.)
then in TextPad I was able to insert text infront of the column names with one command (FILL).
then do the same after the column names and I was done.

I'm spoiled, what can I say...

BUT, the response from another forum was:
"But you don't need to, you can generate sql statements by dragging the table from the navigator tree into a worksheet."

and it works great!


0
 
omgangIT ManagerCommented:
No objection from me angelIII.  bcarlis indicates he found a solution elsewhere.
OM Gang
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Go ahead, No solution because I can not use my solution, TextPad, at my present contract. Against rules.

I just take the extra time to manually do what I need BUT what omgang shared helped expedite my manual editing. Thanks for the help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.