-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
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.
Once again, instead of reviewing each of the Create dialogs available in SQL Developer, we'll look at a few of the more common ones, show...
Change the font size
Change margin width
Change background colour