What's up

I forgot I added a real simple way to see what DBs are up in sqldev a while back. If in the worksheet, you run a command, F5 (run script), "pingall" it will do a tnsping of all the connections defined and report back. From this screenshot you'll notice most of my DBs are down. My plan was to hook up an indicator in the tree for down database but never got it well tested.

More Apex/SQLdev

Here's a couple more shots of the up coming Apex and SqlDev intergration.

1) Export your app:



2)Import the app:


3)Import Options:

SQL Injection scanners

Here's a list of the free sql injection tools over on security-hacks.

Releases

In the last week, the team has released 3 times.

1) SQL Developer 1.1.3 was released
2) Jdev 11 Preview was released where sqldev is built in
3) SQL Developer Migrations EA #2 was minutes ago posted. If your running 1.1.3, you'll see the update balloon soon.


However, I looked up some stats on usage and the majority of people are using 1.0.0 which was release March 2006. Here's the release notes for 1.1.3 so you can see what your missing.

Process a zip file

Some one on the forum asked for an example of how to bulk upload files. Here is an example I used a couple years ago of processing a zip file and uploading the individual files into a table. Then we made an application to manage the file and followed "Create a Procedure to Download Documents" to download.

Here's the sql for the table and sequence:

create table docs(doc_id number,blob_content blob,file_name varchar2(2000));

create sequence doc_id_seq;