Enchancement Request: Paste comma separated

[BWendling]

Often, I need to paste a list of numbers into the IN LIST()-Operator such as: WHERE col IN (...)

The proposed function "Paste comma separated" would need to:
- Enclose all values with apostrophe ('). (This can be done with all types of data: In case of "col" is of type number, the apostrophe does no harm, since Oracle implicitly converts into number.)
- Separate all values with comma

Thank you!

Example:
Instead of pasting:
1
2
3

this new function would do:
'1','2','3'

 

[Robert_G]

sounds like a job for PLSQLDV's special copy.

;PL/SQL Developer SpecialCopy definition
; --> in list (strings) <--
;this one will format a list containing:
; 1
; 2
; 3
;to:
;in ( '1'
;    ,'2'
;    ,'3')
;--------------------------------------------
in ( '<line_1>'
    ,'<line_*>'
    ,'<line_n>')

or only numeric:

;PL/SQL Developer SpecialCopy definition
; --> in list (numerics) <--
;this one will format a list containing:
; 1
; 2
; 3
;to:
;in ( 1
;    ,2
;    ,3)
;--------------------------------------------
in ( <line_1>
    ,<line_*>
    ,<line_n>)

How to? You simply create 2 text files in the subdirectory SpecialCopy of PLSQLDV, you can name them "In list string.copy" and "In list numeric.copy".
The next time you open the context menu, you will see your definitions under Special Copy. (No need to restart the IDE )

 

[BWendling]

Thank you Robert, das funktioniert prima!

 

[ScottMattes]

Kewl! I knew that there was a reason for reading this group each day!!!!!

 

[ScottMattes]

Is it just me, or doesn't copy special work for columns/rows in a result grid? When I select a column and do Edit Special Copy and then paste into the SQL Window I get a special copy of the contents of the SQL Window!?!?!?!? Weird.

Please consider this a bug report/enhancement request.

 

[rbrooker]

this is great when you are copying from an editor, i cant get it to work from the results of a sql window. there is no "special copy" on the context menu.

I have to copy the text into an editor and THEN do a special copy.
any suggestions?

 

[Robert_G]

That would be great!
But it's not that bad to copy it into some Editor window. It's still one of my most beloved features.

 

[Bo Pedersen]

That's a great functionality. But user always wants more, and so do I.

The line constants are only replaced once in each line expression. I would like it to be replaced at all occurences. F.ex. to get a list of constants:

<line_1> constant varchar2(60) := '<line_1>';
<line_*> constant varchar2(60) := '<line_*>';
<line_n> constant varchar2(60) := '<line_n>';

Currently, the second instance of the line constant is not replaced.

Bo Pedersen

 

[ScottMattes]

I just ran into the need to convert

this, that, something

into this

= this
= that
= something

If it can't be done with SC as it is, how about a Word option that parses words v. lines?

 

[Marco Kalter]

This is indeed not possible with Special Copy, which is line-based. A little macro might do the trick though.

 

[rbrooker]

try the pasteoptions by clouds...