Working with Database Objects

An Oracle Database stores and organizes information. Oracle SQL Developer is a tool for accessing and maintaining the data in the database. Tables are the basic storage structure for holding business data. In this module, you learn how to use data definitions (DDL) to create tables and work with them.

You may want to modify data entered in tables. You may also want to maintain the relationships between the data. Sometimes, you may want to remove tables that are no longer useful.

Now that Sheila has the Oracle SQL Developer software installed and working, and has familiarized herself with the tables in the HR schema, her next task is to build some tables. In the demonstrations, you help Sheila create and modify tables, manage constraints, and remove tables.