New feature to add : Copy Special

[Olivier_from_Brussels]

Hi guys,

I would suggest to add a new feature in pl/sql developer to allow people to make a "special" copy/paste with the data's. Example, copy all data's of a column comma separated, or with a semi-column,... this should be great if you want to re-use data's in a query, and more especially in a "in" clause.

Regards

Olivier

 

[Stew Stryker]

It's IN there!

RTFM "Special Copy"

 

[rbrooker]

there is also a plugin by Clouds called "paste options", this gives you all sorts of flavours of paste...

 

[Olivier_from_Brussels]

Stew, what's RTFM ?

 

[Marco Kalter]

Read The Fantastic Manual

 

[Olivier_from_Brussels]

Mmmm... that's the kind of stuff I don't like to do ... but I'll have an eye.

Thanks all for your help

 

[Theod]

I,ve created a IN.copy like

;PL/SQL Developer SpecialCopy definition
; for first line
; for all other lines
; for last line
;
IN ('',
'',
'');

It works fine, but unfortunately not direct in the Query result window, because there is special copy not in the menu.

So I query, mark one colum, copy and paste it in a new edtor, there a can use special copy and paste it again.

PS: The plugin PasteOptions don't work, I don't find the 2 new Standard-MenuItems ExcelFormat and MultiPaste

 

[rbrooker]

multipaste and excelpaste are on the edit menu, directly under cut / copy / paste.

for me anyway...

 

[Theod]

Jap, there should they be, and now they are.

I've figured out, that the shortcut-workdirectory MUST be the program directory where PL-Developer was installed in. I've had there 'z:\work'.

And here is the PasteOption

// InPaste: will convert a column of values copied from a Colums in the Query-Result-Window to values enclosed in single quotes and separated by commas, heading 'IN (' and trailing ')'
// 1) Strip all control chars and spaces
// 2) Replace all CR\LF with

 

[Stew Stryker]

I was such a smart-aleck to this original question and I was wrong! As Theod said, you cannot select values from your query results and use the Special Copy features.

The PasteOptions plug-in works for this, provided you add Theod's addin above.

Marco, any chance Special Copy could be made to work with the query results columns? I regularly select a bunch of values from a single query result column, then need to turn them into an IN clause.

e.g.

IN ('0000185619','0000185621','0000185624','0000185623','0000185629')

Thanks,

Stew

 

[T-Gergely]

Marco, any chance Special Copy could be made to work with the query results columns?

+1

 

[Bernhard S]

I would like another Special Copy for query results: I want an option to copy the query output in a "SQL Window" the way the output of the same query would be in a "Command Window". I often run into a situations where I decide to save the result of a query from a "SQL Window" in a well readable format for documentation purposes or to send it out in an email directly in the text, not as an *.csv or *.xls attachment. One option then is to run the query actually again in a "Command Window", which is annoying for long-running queries. Another option is to manually reformat the query result, so it looks like the output from a "Command Window", which is annyoing too, especially when you have a larger number of rows and columns.

Another bothering formating issue is the default formats for columns in a "Command Window" result. By default all my DATE type formats only show the date part, not the time part of it.

SQL> select sysdate from dual;

SYSDATE
-----------
21.05.2012

To get the time part I have to define column format for each DATE type column like this:

SQL> col sysdate format a20
SQL> r

SYSDATE
--------------------
21.05.2012 13:02:13

SQL>

I want the default there to include the time part already.
I also wonder how the default format is set for other columns often it's too wide or sometimes too small. I would like a smarter auto-adjust feature there.