Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 9. MANAGING SCHEMA OBJECTS (9.01 Create and Modify Tables (Naming…
Chapter 9. MANAGING SCHEMA OBJECTS
9.01 Create and Modify Tables
Type of PERMANENT table
HEAP table
INDEX-ORGANIZED table
PARTITIONED table
CLUSTER table
In Oracle DB: User = User account = Schema
Naming Schema Object Rules
Long:
1-30
;
Database link
: up to
128
Not
RESERVED words
Begin
with a
letter
from A through Z
Only
LETTERS, NUMBERS, UNDERSCORE(_), DOLLAR SIGN($), HASH SYMBOL
Auto
convert lower to upper
DOUBLE QUOTES can
break
all above rules (except the length)
Object Namespaces
Same namespace
Tables
Views
Materialized views
Sequences
Private
synonyms
Stand-alone
procedures
Stand-alone
stored functions
Packages
User-defined types
Own namespace
Indexes
Constraints
Clusters
Database triggers
Private database links
Dimension
Datatypes
Space
Fixed length
Variable length
Alphanumeric data
VARCHAR2
Variable-length
1 byte to 4 KB
Character
NVARCHAR2
As VARCHAR2
Permitted Unicode
CHAR
Fixed-length
1 byte to 2 KB
Padded with spaces
Character
RAW
Variable-length
Binary
1 byte to 2 KB
NOT converted by Oracle Net from
database
to
user process
Numeric data
Date and time data
Large object datatypes
9.02 Manage Constraints
9.03 Create Indexes
9.04 Create and Use Temporary Tables