It was time for another push of the new sql command line , sqlcl. Here's the changes in the latest build. There are a number of bugs fixed relating to connecting to idle databases, alias feedback, and picking up the $ORACLE_HOME's jdbc driver when available. There is only a couple functional changes.
First is that now the jdbc connect string itself can be specified. This opens up a number
Death and taxes – add “software problems” to that list of the inevitable. There is always a new issue, a new failure, a new key opportunity that an organization must address. And to avoid repeating the problems, or to revise your prior fixes, it is critical to capture the problems accurately and completely. You need […]
To allow the consumer to recognize a specific fault, you add it as a fault to the WSDL. This looks similar to the following:
A new SQLCL build was just posted go grab it and kick the tires. There are well over 100 bug fixes in there so it's better than ever. Also there's some new things.
Imagine you have an api that is called and a password or something is used in the parameters. We use exec MY_API(...) and it works just fine. However consider if someone with access to v$sql they just got
If you try to install oracle forms & reports 18.104.22.168 on SLES 11.3 than despite all installer checks are passed maybe you get a message like:
Error in invoking target ‘install’ of makefile ‘/sqlplus/lib/ins_sqlplus.mk’.
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