Tuesday, June 30, 2015

What's New

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 feature. Here's a very short example of javascript batch inserting 4 records into the EMP table. I'm not sure it can get much easier.

Tuesday, June 16, 2015

By the Numbers

There's a new SQLcl out for download. In case, there are too many to keep track of the build numbers are quite easy to tell if you have the latest. The build posted today is sqlcl-4.2.0.15.167.0827-no-jre.zip

Here's what we are doing
4.2.0 <-- doesn't matter at all
15 <- year
167 <- day in julian
0827 <- time the build was done

So yes, this build was done today at 8am !

Info on PL/SQL

I don't think I covered this before. The info on any plsql gives you actual useful stuff. It prints out a stub of pl/sql that can be copy and pasted to get going much quicker than looking at a describe tabular output of args. I'll pick on dbms_metadata which is a huge package.

This can still be way too much 'info' if the packages are very large. The other part of info is that you can get a subset. Here the ".a" was added to filter it down. I'll blog more on why I'm showing metadata as there's some pretty interesting usages that I just found how to use.

Show All

Not much to see here. Just looks like it should.

Show All+

Much like the info/info+ we added lots more. Just scroll over this or try it out and see how much more is there. It should give you just about anything you may be interested in.