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
Control When Oracle SQL Developer Completes Your Code
In the SQL Developer group on OracleCommunity.net, both Chris and Chen complained about the new SQL Developer’s automatic code completion and how it could freeze the entire editor while waiting for the popup to appear.
I have experienced this behavior too. It is really frustrating when it happens. The solution, however, is really simple. In SQL Developer, go to Tools > Preferences > Code Insight and uncheck both “Enable Auto-Popup” check boxes as seen in the following screenshot:
Now, instead of letting it load automatically, you control when the context sensitive code completion insight popup appears. Simply press Ctrl+Space and voila.
By the way, Vadim Tropashko has a great article about getting most of code completion in SQL Developer.
Filed in Oracle with Comments Off | Tags: sql-developerBetter SQL Formatter in Oracle SQL Developer, Finally a Reality
As mentioned on OracleCommunity.net, Oracle SQL Developer 1.5 Early Adopter 1 (EA1) is now available for download. As with any new release, there are new features and bug fixes. But, they are not yet detailed in the release notes.
However, I know that the one feature that I have been eagerly waiting for is finally here, it is the brand new and enhanced SQL Formatter (screenshots below). Not bad at all!
I’ll be using SQL Developer 1.5 as my main SQL and PL/SQL development tool for the next few days and weeks. Let’s see if this release will convince me to ditch Quest’s SQL Navigator.
Oracle SQL Developer 1.2 Released
Oracle SQL Developer, the free graphical tool for database development, has just been upgraded from 1.1 to 1.2. Here is the list of bug fixes and here is the release notes document including new features and known issues.
If you are already running production release 1.1 (v 1.1.0.23.64) or above, you can use Help > Check for Updates to update your SQL Developer environment. Otherwise, you can download Oracle SQL Developer 1.2 from here.
Filed in Oracle with 1 Comment | Tags: sql-developerThe Case of Better Readable Code
When you code, you write your programs either in all lower case, all upper case, or a combination of the two. Let’s take PL/SQL for example, almost all PL/SQL programming best practices and coding styles that I’ve come across recommend using upper and lower. The following is an excerpt from the book Oracle PL/SQL Best Practices By Steven Feuerstein: (more…)
Oracle SQL Developer 1.1 New Features
Sue mentioned two SQL Developer 1.1 new features today. 1) Sort on column headers, available on any grid of data. 2) Display a single record on a form layout. Cool.
Filed in Oracle with 6 Comments | Tags: sql-developerSQL Developer and UTF8
In this global economy the need for software globalization is increasing. As a result of this globalization, localization is becoming an important part of software development. And as a result of this localization, software developers like myself will have to work with multiple languages. So, it is becoming more crucial to have development tools that support multi-byte in addition to single-byte characters, like Chinese versus English for example.
As an Oracle database developer I have been using Quest Software Inc.’s SQL Navigator for years. We are currently involved in the implementation of Oracle E-Business Suite in our new plant in China. So, now we have the Chinese characters to worry about. It turns out that SQL Navigator does not support multi-byte characters and UTF8 encoding (which is needed to display Chinese characters), however, Oracle’s SQL developer does 
Here is how SQL Navigator displays a query result that returns Chinese characters: (more…)
Filed in Oracle, Tips with 23 Comments | Tags: sql-developer, sql-navigator, toad, tool, utf8Oracle SQL Developer Graduated
Following up on my last post: Oracle SQL Developer Updated, it was finally decided to release SQL Developer to production. So, go ahead and get your fresh copy from OTN.
Oracle Database 10g XE has this:
It would be nice to have a similar one for SQL Developer as well, would it?
Filed in Oracle with Comments Off | Tags: software, sql-developer, toolOracle SQL Developer Updated
Another day, another Oracle SQL Developer release. That brings the current release to:
Early Adopter Release 7, version 1.0.0.14.54
March 8, 2006
To get an idea of the frequency of new SQL Developer EA releases: (more…)
Filed in Oracle with 4 Comments | Tags: software, sql-developer, toolYANC – Yet another name change
First, Oracle HTMLDB was renamed to Oracle Application Express. Now, it looks like Oracle Project Raptor is going to be renamed to SQL Developer (Express?), as noticed in Sue Harper’s presentation at ODTUG.
Filed in Oracle with 2 Comments | Tags: application-express, sql-developer
