SQL With Oracle Database
Oracle SQL Developer
In addition to Oracle Application Express and SQL*Plus, you can also use Oracle SQL
Developer for database development and administration. Oracle SQL Developer is a free,
thick-client graphical tool. You can use it to execute SQL statements, view metadata, execute
and debug PL/SQL statements, and run some SQL*Plus commands (like DESCRIBE). SQL
Developer includes a database modeler, and a module to assist migration to Oracle Database.
SQL Developer can connect to Oracle databases from version 126.96.36.199 onwards. Metadata
and data from several third party databases, including MySQL Database are also viewable.
SQL Developer is available on Linux, Windows and Mac OS X.
You can download SQL Developer from the Oracle Technology Network at
http://www.oracle.com/technetwork/developer-tools/sql-developer. You can also
download extensions, documentation, and other resources from this site. There is also a
discussion forum for you to ask questions of other users, and give feedback to the SQL
Developer product team.
Creating a Database Connection in SQL Developer
When you start SQL Developer for the first time there are no database connections
configured, so the first thing you need to do is create one. The default SQL Developer screen
is shown in Figure 33.
Figure 33: Oracle SQL Developer login screen.