Wednesday, October 25, 2006

Oracle SQL Developer 1.1 with Kris Rice

w00t! Just cadged an Unbreakable Linux baseball cap.

Kris Rice is doing some very cool work. Its his job to create a complete Oracle development environment, bit by bit. The day will come when users of Toad will be clicking the 'uninstall' button.

He showed off some nice stuff, like how you can extend the interface using nothing more than XML. It seemed almost too easy to add items to the right-click menu. If you've done any work on extensions to JDeveloper, apparently, its identical. Check out Kris' blog for some examples here.

It was good to see a live demo of remote debug. He demonstrated how you could use it to debug Apex (They say it 'appex', not 'aypex', and they say 'varcar', not 'varchar' too), or at least packages called by Apex. The debugger is able to present recordsets in watch variables, which many people will find handy.

There's a facility for running packages from the interface, like you get in Toad - it prompts for bind variables in the same way as the Quest product.

Reports are not just reports anymore. The sessions report, for instance, allows you to kill sessions using the right-click menu. You can also get charts, and they look pretty good (though you can't print them at this stage).

SQL Developer Exchange is a website where you can share code snippets and reports with other users. This is current functionality. What they have planned for a future release is being able to access your saved scripts from OTN from within SQL Developer. Think of this a bit like del.icio.us for SQL.

0 Comments:

Post a Comment

<< Home