[App_F.pptVIP

Using SQL Developer Objectives After completing this appendix, you should be able to do the following: List the key features of Oracle SQL Developer Install Oracle SQL Developer Identify menu items of Oracle SQL Developer Create a database connection Manage database objects Use the SQL Worksheet Execute SQL statements and SQL scripts Edit and debug PL/SQL statements Create and save reports What Is Oracle SQL Developer? Oracle SQL Developer is a graphical tool that enhances productivity and simplifies database development tasks. You can connect to any target Oracle database schema by using standard Oracle database authentication. Key Features Developed in Java Supports Windows, Linux, and Mac OS X platforms Default connectivity by using the JDBC Thin driver Does not require an installer Connects to any Oracle Database version and later Bundled with JRE 1.5 Installing SQL Developer Download the Oracle SQL Developer kit and unzip it into any directory on your machine. Menus for SQL Developer Creating a Database Connection You must have at least one database connection to use SQL Developer. You can create and test connections: For multiple databases For multiple schemas SQL Developer automatically imports any connections defined in the tnsnames.ora file on your system. You can export connections to an XML file. Each additional database connection created is listed in the Connections Navigator hierarchy. Creating a Database Connection Browsing Database Objects Use the Database Navigator to: Browse through many objects in a database schema Review the definitions of objects at a glance Creating a Schema Object SQL Developer supports the creation of any schema object by: Executing a SQL statement in the SQL Worksheet Using the context menu Edit the objects using an edit dialog box or one of the many context-sensitive menus. View the DDL for adjustments such as creating a new object or editing an existing schema object. Creating a New Table: Example Using the SQL Wor