Oracle Database - Objects

Card Puncher Data Processing

About

Database object.

Each database object is considered to either be:

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

Object in different namespace are allowed to have identical names.

List

Type

Non-Schema

Schema

See Oracle Database - Schema Object

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;





Discover More
Card Puncher Data Processing
How you can use a bind variable in SQLPlus

This page is specifically about the usage of SQL bind variable in SQLPlus.
Oracle Segment Extent Data Block
Oracle Database - (Logical) Segment (Database Object Storage)

A segment is a logical storage structure that contains data structure (segment type) of database objects. For example: each table's data is stored in its own data segment, while each index's data...
Card Puncher Data Processing
Oracle Database - Naming convention

Below is the naming convention for database object Two objects can not have the same name in the same namespace. The namespace is normally the schema where the object is created excepted for an index...
Card Puncher Data Processing
Oracle Database - Schema Object

The schema Objects are logical structures of data stored physically in data file and categorized in a schema. private synonym Database objects that are owned by a user are schema...
Card Puncher Data Processing
PL/SQL - Object datatype

The Object datatype in PL/SQL Disambiguation: See The AUTHID clause determines whether all member methods execute with the privileges of their definer (the default) or invoker, and whether their...



Share this page:
Follow us:
Task Runner