Oracle Overview and Architecture

1
Oracle Overview and Architecture

• Architecture of an Oracle9i Database
• Oracle9i Objects
• Schemas
• Tablespaces
• Tables
• Indexes
• The Role of SQLPlus for Interactive SQL
• Table Specifications
• Table components
• Column datatypes

2
Oracle9i Database Objects
Schema Database
Table-2
Table-1
Tablespace-1
Table-3
Tablespace-2
View-1
Tablespace-3
4-2
3
Oracle9i Interactive SQL
4
Table Specification

• Column_constraint
• Primary_key
• Foreign_key
• Not null
• Unique
• Check
• Table_constraint
• Primary_key
• Foreign_key
• Check

• Table_specification
• Table_name
• Column_specification
• Table_Constraint
• Column_specification
• Column_name
• Datatype
• Column_Constraint

5
Table Specification - Basic Syntax

• CREATE TABLE table_name (column_name_1 datatype
  column constraintscolumn_name_2 datatype
  column constraints ...column_name_n datatype
  column constraintstable constraints)
• CREATE TABLE, INDEX, VIEW
• ALTER TABLE, INDEX, VIEW
• DROP TABLE, INDEX, VIEW

6
Datatypes

• Common Oracle Datatypes
• CHAR(size)
• VARCHAR2(size)
• NUMBER(p,s)
• DATE
• ROWID