The social network for Oracle people

SQL Developer 1.5

Have you downloaded SQL Dev 1.5 EA1 yet? What do you think of it?

Permalink Reply by Chris Muir on February 14, 2008 at 11:16pm: I like the new SQL History window. I'm finding the auto-complete feature a pain because of the delay and it interferes with the keys I can press on the keyboard, and occasionally when I open packages I lose the ability to click on the IDE. Still needs some work, but I expect nothing more for an EA release ;)

CM.; ▶ Reply to This

Permalink Reply by Bradd Piontek on February 15, 2008 at 5:08am: I've downloaded it and installed in its own directory. The one thing I've been waiting for is for them to fix the Compare Schema piece. While it seems better in 1.5 EA1, it still seems to expect you to be connected as the schema owner on one of the schemas, which is unusable.; ▶ Reply to This

Permalink Reply by Michael FLiegner on April 29, 2008 at 1:30am: Even the Code Editor would only for for owner connections. Regardless what permissions Your connection has otherwise.
Not entirely unusable but quite often.; ▶ Reply to This

Permalink Reply by Don Seiler on February 15, 2008 at 6:03am: The migration tool worked better in 1.5EA1 than the latest stable release. By "better" I mean that it worked at all. Trying to migrate and MSAccess db into an Oracle schema hung and then failed in 1.2.; ▶ Reply to This

Permalink Reply by Chen Shapira on February 15, 2008 at 10:47am: I'm not using SQL Developer for anything fancy, but I think they added much more hints and tooltips in the new version, and I find that incredibly annoying. They are annoying when everything works perfectly, and triple annoying when the entire editor freezes for 5 minutes while a tooltip is loading.; ▶ Reply to This

Permalink Reply by Eddie Awad on February 15, 2008 at 1:22pm: I agree with Chris and Chen about the code auto completion issue. I have just written a quick post about it on my blog: Control When Oracle SQL Developer Completes Your Code.; ▶ Reply to This

Permalink Reply by Sven Vetter on March 3, 2008 at 4:17am: I've downloaded EA2 now.

You have a lot more formating options - nice.
And a new option "Monitor sessions" - a step more in direction TOAD ;-); ▶ Reply to This

Permalink Reply by Sven Vetter on March 4, 2008 at 3:20am: I have a problem with the new formater. This tool delete all my empty lines. And sometime I want have a empty line for better overview...
Have everybody found a option to switch this off?

Thanks
Sven; ▶ Reply to This

Permalink Reply by Eddie Awad on March 4, 2008 at 10:21am: I have not found an option to preserve empty lines either. I have posted your question on the SQL Developer OTN forum here.

In the mean time, you can add an empty comment to the empty line, like -- or /**/, that should make the Formatter leave it alone.; ▶ Reply to This

Permalink Reply by Al Mason on April 25, 2008 at 10:01am: Hello everyone,

I am using SQL Developer on a project. When I open and run scripts throught it there seems to be an issue with comments delimited by --. It returns an unknown command error when -- is encountered. I am looking for a configuration parameter to fix this but haven't found one.

Regards,
Al Mason; ▶ Reply to This

Permalink Reply by Al Mason on April 25, 2008 at 10:37am: Evidently the issue is only when the comment doesn't start on column one.

SQL Window

-- test_comments.sql
select name from v$database;
select name from v$database; -- comments after command

Results Window

NAME
---------
ORCL

1 rows selected

Error starting at line 3 in command:
select name from v$database; -- comments after command
Error at Command Line:3 Column:27
Error report:
SQL Error: ORA-00911: invalid character
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:; ▶ Reply to This

Permalink Reply by Eddie Awad on April 25, 2008 at 3:19pm: Hummm! I could not reproduce your error. I have the latest production SQLDev version 1.5.0.53 Build 53.38 on Win XP Pro.
Do you get the same error if you use /* */ instead of --?; ▶ Reply to This