Toad World® Forums

Copy/Paste while creating or altering a table


#1

In TOAD, can I copy multiple lines and then add them at the bottom of my table? I have several recurring fields that it would be nice to copy and insert rather than having to enter them all individually.


#2

You are talking about adding column to a table?

Yeah, you can only add one at a time in the GUI because it wants you to specify a column name as you go, but as a workaround you could just a “q” for the first column name, then arrow down, “w”, arrow down, “e”, arrow down, “r”, arrow down, etc, then come back after and paste in the names that you actually want.

If you have a long list of column names and you just want to paste the whole list, it might be easiest to use the GUI to add one column, then do a Show SQL, send the SQL to Editor, and then you can paste the rest in to the ‘alter table’ statement that the GUI creates for you.


#3

Thank you sir

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, March 06, 2018 9:36 AM

To: toadoracle@toadworld.com

Subject: [EXTERNAL] RE: [Toad for Oracle - Discussion Forum] Copy/Paste while creating or altering a table

RE: Copy/Paste while creating or altering a table

Reply by John Dorlon

You are talking about adding column to a table?

Yeah, you can only add one at a time in the GUI because it wants you to specify a column name as you go, but as a workaround you could just a “q” for the first column name, then arrow down, “w”, arrow down, “e”, arrow down, “r”, arrow down, etc, then come back after and paste in the names that you actually want.

If you have a long list of column names and you just want to paste the whole list, it might be easiest to use the GUI to add one column, then do a Show SQL, send the SQL to Editor, and then you can paste the rest in to the ‘alter table’ statement that the GUI creates for you.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.