Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-31
6
Medium Priority
?
2,058 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

963 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