Solved

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

Posted on 2008-10-31
6
1,878 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

785 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