xpp_C资料参考 学习.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 SQL Worksheet Save and run SQL scripts 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. Specifications of SQL Developer Is developed in Java Supports Windows, Linux, and Mac OS X platforms Has default connectivity by using the JDBC Thin driver Does not require an installer Unzip the downloaded SQL Developer kit and double-click sqldeveloper.exe to start SQL Developer. Connects to Oracle Database version and later Is freely downloadable from the following link: /technology/products/database/sql_developer/index.html Needs JDK 1.5 installed on your system that can be downloaded from the following link: /javase/downloads/index_jdk5.jsp Installing SQL Developer Download the Oracle SQL Developer kit and unzip into any directory on your machine. SQL Developer Interface 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 Multiple schemas SQL Developer automatically imports any connections defined in the tnsnames.ora file on your system. You can export connections to an Extensible Markup Language (XML) file. Each additional database connection created is listed in the Connections Navigator hierarchy. Creating a Database Connection Browsing Database Objects Use the Connections 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