Database Objects
Database Objects is a dynamic object-oriented, repository based layer on top of a database. Database, schema, table, column, primary key, and foreign key are a few commonly used database objects. These can be directly created in the Data Definition view.
A D V E R T I S E M E N T
All objects that belong to the same user are said to be this user's schema.
Information about existing objects can be retrieved from dba_objects.
It is possible to assign object privileges to objects. These privileges control what other users can do with the objects.
In SQL*Plus, information about tables, views, procedures, functions and packages can be shown with describe.
Oracle stores relevant information about objects (such as their definitions, used storage and so on) in the data dictionary.
The definition of database objects can be retrieved through dbms_metadata.
Following are the examples of a few databse objects:
- Tables
- Views
- Indexes
- Clusters
- Synonyms
- Sequences
- Procedures
- Functions
- Packages
- Triggers
|
