Some days the developer in me emerges and then off I go
A couple of days ago I downloaded the new release of JDeveloper. Although I had been playing with the Early Adopter version for some while I wanted to see how the official release looked. I had already recommended it to my Java developers and wanted to make sure my opinion still stood. It did; even I managed to develop simple applets and JSP pages (and in minutes!) from the excellent tutorial stuff on OTN.
One great feature for me is the ability to create database diagrams from existing schemas. Simplistically: create a connection to the database, create a new application, then a new project to use database technology, and finally right click on the project and select new and the select database diagram option. Then go back to the connection tab and highlight all of the tables you wish to include in the diagram and drag them across to the empty diagram. And that’s it, a few moments later (and your experience may differ) you get a lovely diagram with all of the foreign key constraints connecting the tables. I’ve put already this use for one customer to identify missing RELY constraints in a data warehouse. So JDeveloper is not just for developers.