Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL developer or jDeveloper?

Richardho_gemSep 26 2012 — edited Sep 26 2012
Hi one and all,
At work we're now looking to move away from TOAD as we'll soon to be learning Java to enhance our future developments and we would ideally like a 'one stop shop' for our editors, so I was wondering what everyone's opinion was on whether we can get away with using jDeveloper or do we need SQL developer as well?

Does the SQL editor in jDeveloper have all the functionality of SQL developer or is it just a cut down version?

From experimenting in jDeveloper it doesn't seem to function the same way as SQL Developer but I'm not sure if that's due to bugs in jDeveloper?

I'm using JDeveloper Studio 11.1.2.2.0 and I've been comparing it to SQL developer 3.1.07

Example 1:
In jDeveloper you can't highlight a table name and open the declaration unless you have a full command string;

i.e. If I highlight the word dual in the the following string 'SELECT * FROM dual;' I can right click and open the declaration, if I just type the word dual and highlight it it won't do anything? This works for any table name btw.

Example 2
When I do open the declaration for the table, when you go to the SQL tab to see the script that created the table, jDeveloper doesn't give you the code whereas SQL developer does?


Cheers for any opinions given.

Richard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2012
Added on Sep 26 2012
2 comments
3,080 views