Solved

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

Posted on 2008-10-31
6
1,855 Views
Last Modified: 2013-12-07
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
0
Comment
Question by:bcarlis
  • 2
  • 2
6 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 22852362
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
 
LVL 2

Author Comment

by:bcarlis
ID: 22904032
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
 
LVL 28

Expert Comment

by:omgang
ID: 23121196
No objection from me angelIII.  bcarlis indicates he found a solution elsewhere.
OM Gang
0
 
LVL 2

Author Comment

by:bcarlis
ID: 23138853
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23154757
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now