Here's just one more variation on how to get a CSV into a table format. It could have been done before but my google-fu couldn't find it anywhere.
First to get some sample data using the /*csv*/ hint in sqldev.
Then the results of putting it back to a table. The inline plsql is just to convert the text into a CLOB.
Now the details.
The csv parsing is completely borrowed(stolen) from
In some situations you may need to hide the actions that are shown in the Actions drop-down in Workspace.
The new command line is a must try, says 10 out of 10 people that built it. The tool has sshtunneling of ports built in as described by Barry.
This means you can script opening your sshtunnel from the command line and run sql very quickly. Here's the one I used recently at Kscope15.
Now the trick? is that once this port is forwarded, any tool can now use it. In case
In this blog article I explain three options to config
For the BPMN modelers among us, I have a small quiz.
Given a process model like this, what would be the behavior of Oracle BPM?
For the 90%+ of people using sqldev/modeler on windows, the JDK bundled versions are back. So no more debating what to install or worrying about conflicting Java versions.
Lots of bug fixes.
My favorite bug is now fixed so you can use emojis in your sql> prompt.
RESTful CSV Loading
We wrapped he same CSV import code in SQL Developer into the REST Auto-Enablement