Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Paste text lines as a quoted, comma-separated IN expression list

Hi,
does SQL Developer provide a copy and paste trick to paste text as a comma-separated expression list suitable for use in a SQL IN clause?
For example, I would like to copy the following lines of text:

FOO
BAR
BAZ

and then being able to paste it in SQL Developer like this, without resorting to search/replace:

'FOO',
'BAR',
'BAZ'

(Note the quotes around each line and the commas after each line.)
If SQL Developer doesn't already allow this trick... how can I submit a new feature request?
Thanks

This post has been answered by thatJeffSmith-Oracle on Feb 22 2021
Jump to Answer
Comments
Post Details
Added on Feb 18 2021
4 comments
975 views