Feature Details

Copy&Paste Option: Copy Column Values - Remove Duplicates

I observed myself during my daily work and realised that I keep switching between Excel and SQL Developer. Why?

Because Excel has a feature 'Remove Duplicates'!

So I paste the values into Excel, remove the duplicate values, add apostophes and commas via a formula so that I get a list like

'FR123456789',

'DE123456789',

'US123456789'

which I then copy an paste back into SQL Developer to continue my work.

It would be great if SQL Developer could do this tedious task for me - maybe with our without apostrophes depending on the data type.

9.69

Open

Ratings/ Comments

Comment	Score	Created On
	10	30-AUG-19
	10	31-JAN-18
	10	25-SEP-17
drag and drop values from results grid to worksheet as a comma separated list is great for numbers but for varchar it needs quotes adding manually. Including the ability to add apostrophes depending on the data type would be a time saving feature I would love.	10	26-JUL-17
I could live without removing dups, but please quote character data types.	10	25-JUL-17
	8	24-JUL-17
	10	18-MAY-17
Very useful	10	15-MAY-17
	10	05-JAN-16
	8	17-DEC-15
	10	02-NOV-15
	10	02-NOV-15
A big time saver!	10	06-DEC-14

1 - 13