OBE 11g: Managing Schema Objects

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. You can create and manipulate schema objects using Oracle Enterprise Manager.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you learned how to:

• Query for tables in a specific schema.
• Create an table and view the attributes and contents of the new table.
• Create a view.
• Manage database resident program units.
• Load data into an existing table.

Ir a la lección