How to convert oracle sql to java or python string in Oracle SQL Developer 4

If your using Oracle SQL Developer to write and test query’s that you will use in a Java or Python program this will be a handy tip, you don’t have to do this manually.

1. In your current Worksheet right click and select “Embed/Expose…” Or press keyboard shortcut Ctrl + Shift + F7

   

2. Set the output destination to “Clipboard” otherwise conversion will be done over your existing worksheet SQL.

3. Select Output Type To / From Java or Python

4. Click Apply button.

5. Finally, paste the conversion where you need it at.