3 The SQL and Data Modeler Pages

Use the SQL page to enter and execute SQL and PL/SQL statements and create database objects. The Data Modeler page enables you to create diagrams from existing schemas, retrieve data dictionary information, generate DDL statements, and export diagrams.

Topics

• The Overview Page

• The SQL Page

• The Data Modeler Page

• Creating and Editing Database Objects

• The Overview Page
  The Overview page contains widgets that provide a general overview of the activity in the SQL and Data Modeler pages.
• The SQL Page
  The SQL page enables you to enter and execute SQL and PL/SQL statements, and create database objects.
• The Data Modeler Page
  The Data Modeler page provides an integrated version of Oracle SQL Developer Data Modeler with basic reporting features. You can create diagrams from existing schemas, retrieve data dictionary information, generate DDL statements, and export diagrams.
• Creating and Editing Database Objects
  You can create and edit objects using Create and Edit Object wizards available from the Navigator tab in the SQL and Data Modeler pages.