To create a new connection, you can use the procedure described in figure 2-4. When you start SQL Developer, the Connections window displays all available database connections. To connect to earlier versions, you need to use another tool such as the SQL*Plus tool described in the previous figure.īefore you can work with a database, you need to create a connection to the database. When you use SQL Developer, you can connect to any Oracle Database version 9.2.0.1 or later. This chapter is excerpted from the book, Murach's Oracle SQL and PL/SQL, authored by Joel Murach, published by Mike Murach & Associates, Inc., August, 2008.
However, with some minor variations, the skills presented in this chapter should work for later versions as well. As you will see, this tool makes it easy for you to review or modify the design of a database.Īs of press time for this book, the current version of SQL Developer is version 1.5, so that's the version presented in this chapter.
Oracle SQL Developer is a free graphical tool that makes it easy to work with Oracle databases, and it's the tool that we recommend for working with an Oracle database.
ORACLE SQL DEVELOPER NEW DATABASE CONNECTION HOW TO
How to use the Oracle Database SQL Reference manual How to use SQL Developer to run SQL statements How to view and edit table column definitions How to use SQL Developer to work with an Oracle database How to work with the Oracle database home page
0 kommentar(er)
