Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-31
6
Medium Priority
?
2,019 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

715 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