Creating new database objects
In the first section of the chapter, we looked at browsing objects and data in the database. You may, if you are an application developer and working with a completed database design, spend most of your time doing just that. It is more likely, though, that you'll need to make changes such as adding or modifying structures and data. SQL Developer provides the dialogs to assist you.
In the same way that you can write SQL queries to extract information about the objects you have access to, you can write the SQL Data Definition Language (DDL) to create, edit, and modify these objects. Almost all of the object nodes in the Connections navigator provide a context menu to create a new object. To invoke a dialog that creates any new object, select the object in the navigator and invoke the context menu.
The following list is an exception for creating new objects using context menus:
Editioning Views
Queues
Queue Tables
Cross Edition Triggers
Directories
Editions
Application...
