Just updated to 3.1 on my Mac Lion. It's very likely a bug since it used the work with 3.0.
I have a "temp.sql" file where I store several queries. I start SQL Developer, open "temp.sql", connect to a DB but "completion insight" and "change case as you type" won't work anymore.
If I click in "Unshared SQL Worksheet", the new worksheet tab will work fine with completion and change case, but I want to use my temp.sql and save things there when closing the application.
To reproduce yourself the issue:
Open SQL Dev, connect to a DB (it will open a worksheet), do some queries and check that change case and completion are working, quit SQL Dev, but save the worksheet in a sql file before. Re-open SQL Dev and open the sql file. Connect to the same DB and try to change the queries or create another. Completion and change case won't work anymore.
The usual mechanism is to wait for the next full release (a download) or to use the Check for Updates feature for patch releases. Not sure which category the next release will fall into. You'll have to wait for some announcement, either at the top of the forum's first page, or via Facebook or Twitter.
I am using 3.2.20.09 and the problem I've reported is still there.
Since I am tired of waiting, can someone recommend me a Sql IDE that "works" with oracle db server, and I mean, "works" having auto completion etc.? I would gladly pay for such an application if it's work as I hope.
Can't reproduce in 3.2.20.09:
1. Start sqldeveloper
2. Open select.sql with
select * from emp
3. Choose a connection from the dropbox
4. "ctrl-space" at the cursor after "emp" brings up the list of all the expected tables.
Well, it's partially working, if your sql file is big (like mine), say with more than 1000 lines, then, maybe because of memory usage, the automatic completion won't work as expected, though, sometimes, after a while, crtl-space would stil work.
So, the problem may have been addressed, but I believe this feature can be definitely improved.