New SQL Developer 1.5 – Free by Oracle

For the fans of the old and good SQL*PLUS, TOAD (commercial use, but exists a free version with several limitations) and PL/SQL DEVELOPER (commercial use and version of evaluation for 30 days), who not yet know Oracle SQL Developer, I recommend try it, this tools is free and you can download it from OTN. This graphical tool from Oracle had the project initiated back in 2006 and is not only for developers use, is also for DBA’s. Currently, Oracle SQL Developer 1.5 is certified not only to be used with to Oracle Databases 9i (9.2.0.1), 10g, 11g, but also you can use to connect with MySQL, SQL Server, Sybase and Access. (This tool is developed in Java, and can be used under platforms Windows, Linux and Mac OSX)For the fact of this software use a JDBC driver, is not necessary install any client software to use it, just download the zip file from OTN, unzip it and is ready to use.  Because it has a graphic interface, Oracle SQL Developer facilitates the navigation by objects of the data base (tables, views, procedures, constraints, etc…), allowing the creation, edition, deletion and visualization of the codes sources not only of objects, but also of users of data base.  One another important function that it offers is to allow the generation of execution plan of the SQL’s submitted.
Some of the capacities of Oracle SQL Developer 

  • Create connections with different databases

  • Navigate between objects

  • Create objects

  • Edit Objects

  • Consult and to manipulate objects (DML)

  • Export and generate DDL of objects

  • Make copies and comparisons between schemas and objects

  • Process commands

  • Edit PL/SQL code

  • Execute and debug PL/SQL code

  • Execute and create personalized reports

  • Migration integrated Workbench

  • Allow integration with control version systems (CVS)

sqldeveloper_win sqldeveloper

Please, be free to download it and test it.

Regards, 

Francisco Munoz Alvarez 

Note: Based on Eduardo Legatti notes.

Advertisements

Oracle ACE Director and President of LAOUC, NZOUG and CLOUG. Organizer of LA and APAC OTN Tours,

Posted in News
One comment on “New SQL Developer 1.5 – Free by Oracle
  1. legatti says:

    Hello Francisco,

    Thank you for have written and shared it in English …

    Cheers

    Legatti

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: