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 Express
• XML DB Repository
• Recycle Bin

A right-click on the previously listed objects nodes under Connections navigator will not provide us with the Create New option.