Toad World® Forums

Copy/Paste row data in Toad?

Our agency’s department is moving away from PL/SQL Developer to the use of Toad 12.1.0.22. In this transitioning period, we are trying to determine if there is a way to take row data from one database schema and copy it to another database’s schema using COPY/PASTE functionality. It appears that this is available in PL/SQL Developer but not through Toad?

Hello,

While in a Toad data grid, r-click and be sure that “row select” is checked to copy an entire row of data. However, there are plenty of other easier and more
efficient ways to copy data from one place to another in Toad. Try R-clicking on your source table in the Schema Browser and select “copy data to another schema”.

From: acuhadar [mailto:bounce-acuhadar@toadworld.com]

Sent: Tuesday, February 04, 2014 11:02 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Copy/Paste row data in Toad?

Copy/Paste row data in Toad?

Thread created by acuhadar

Our agency’s department is moving away from PL/SQL Developer to the use of Toad 12.1.0.22. In this transitioning period, we are trying to determine if there is
a way to take row data from one database schema and copy it to another database’s schema using COPY/PASTE functionality. It appears that this is available in PL/SQL Developer but not through Toad?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

I appreciate your fast response. We can copy the entire row of data – but the issue is pasting into the other table — We do know about the copy to another schema functionality and that is very useful. However, from a very simplistic standpoint, PL/SQL developer seems to offer this functionality that we still can’t get Toad to do. When we go to paste the row into the other table – it puts all the data into the first column instead of adding the entire row – are we doing something wrong?

Yes, I see what you’re talking about. This seems like it would be a nice feature.

From: acuhadar [mailto:bounce-acuhadar@toadworld.com]

Sent: Tuesday, February 04, 2014 2:11 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Copy/Paste row data in Toad?

RE: Copy/Paste row data in Toad?

Reply by acuhadar

I’m glad you experience the same thing. I know that Toad will create the necessary insert statement for you and those can be saved to the clipboard and run in the other database schema’s table by pasting it into an editor and running the statement —so, that will need to suffice for now until maybe Toad can supply that feature :slight_smile: Thank you for your time…

Just fyi…Not sure this helps, but there is also a kind of quicker way to export the selected rows. In the Schema Browser, go to the Data tab and press
the down arrow next to the Export Dataset tab and you can select the ‘Create insert statements for selected rows’.

Not a lot different, but a little faster than bringing up the full Export Dataset screen.

From: acuhadar [mailto:bounce-acuhadar@toadworld.com]

Sent: Tuesday, February 04, 2014 2:31 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Copy/Paste row data in Toad?

RE: Copy/Paste row data in Toad?

Reply by acuhadar