Working with the Database

Create and use database connections from within JDeveloper for a variety of tasks:

Develop and test database applications.
Browse database objects.
Create, edit, or delete database objects using JDeveloper, the SQL Worksheet, or SQL*Plus.
Use Java to execute SQL statements.
Access Oracle objects, PL/SQL Packages, Java stored procedures, and embed SQL in Java programs.
Work with offline versions of database definitions, and then generate those definitions to a file that is processed immediately or at a time you choose to create a table or other database objects via the database connection.

Topic Title	Topic Description
Configuring Database Connections	Defining, importing and exporting, editing, opening, closing, and deleting database connections. Also, managing database preferences and troubleshooting information.
Browsing Databases	Viewing Oracle Database objects, and choosing how to view or filter objects.
Creating, Editing, and Dropping Schema Objects	Creating, editing and dropping database objects in Oracle Database.
Using the SQL Worksheet	Using the SQL Worksheet to enter SQL statements, execute them, and inspect execution plans.
Launching SQL*Plus	Configuring and launching SQL*Plus from a connection or SQL File.
Using Java to Execute SQL Statements	Writing and executing Java programs that access the Oracle Database. Using object types, object package types, PL/SQL packages, and JPublisher-generated classes in JDeveloper. Creating, testing, and deploying Java stored procedures for Oracle Database.
Working with Offline Database Definitions	Creating, editing, and removing offline database definitions, and using offline database definitions with and without modeling.

Note: If you need help filling in values in a wizard or dialog, click Help or press F1 for more information. You can also browse the Oracle Database documentation at http://www.oracle.com/technology/documentation/database10g.html.