Oracle Database - Objects

About

Database object.

Each database object is considered to either be:

• a schema object (ie owned by a user)
• or a “non-schema object”.

See for plsql object type: PL/SQL - Object datatype

Object in different namespace are allowed to have identical names.

Articles Related

List

• Clusters
• Constraint
• Contexts
• Database links
• Database triggers
• Dimensions
• Directories
• External procedure libraries
• Indexes
• Operators
• Packages
• Profiles
• Restore points
• Roles
• Rollback segments
• Sequences
• Index-organized tables
• Indextypes
• java classes, etc.
• Materialized view logs
• Materialized views
• Mining models
• Object tables
• Object types
• Object views
• Stored functions/procedures
• Synonyms
• Tables
• Tablespaces
• Users
• Views

Creation

• In line

create table employees
(
   emp_id    number primary key,
   emp_name  varchar2(30)
)

• Out of line. Excepted for the NOT NULL constraint

create table employees
(
   emp_id    number,
   emp_name  varchar2(30)
   constraint emp_id_pk primary key (emp_id)
)

• Alter

create table employees
(
   emp_id    number,
   emp_name  varchar2(30)
);
alter table employees modify emp_id constraint emp_id_pk primary key;