Oracle SQL Developer 2.1 EA1 Released

Oracle SQL Developer 2.1 Early Access 1 is available for download. Please review the Release Notes before you start. For all other supporting documents, please visit SQL Developer on OTN.

Here's the new feature list :
http://www.oracle.com/technology/products/database/sql_developer/files/NewFeatureList21.htm

Here's the OBE for the new Unit Testing:
http://www.oracle.com/technology/obe/11gr2_db_prod/appdev/sqldev/sqldev_unit_test/sqldev_unit_test.htm

Download it from http://www.oracle.com/technology/software/products/sql/index21_EA1.html

Oracle SQL Developer doesn’t support the full Windows 7 Aero Theme… or does it?

Tired of your IDE swapping back to Aero Basic whenever you launch SQL Developer?  Me too.  For now, Oracle reports that SQL Developer doesn’t support the full Aero Theme… or does it?

To enable Aero support (or at least keep it from bouncing back to Aero Basic), open up sqldeveloper.conf and add the following line:

AddVMOption -Dsun.java2d.noddraw=true

It worked for me. I installed SQLDev in C:\sqldeveloper, so sqldeveloper.conf exists in C:\sqldeveloper\sqldeveloper\bin.

Formatting SQL in Oracle SQL Developer Can Output Different Formats

I especially like the "Concatenated SQL" which sometimes can come in handy when writing dynamic SQL. However, I wish I could make it use single quotes instead of double quotes.