Versions Compared

Old Version 14

changes.mady.by.user OO_heerock

Saved on

compared with

New Version Current

changes.mady.by.user OO_heerock

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents


Overview

In ORACLE, there are two ways to create constraints. Inline constraint and out of line constraint. ALTIBASE HDB is same as well.

Example

ORACLE

ALTIBASE HDB

Comments

alter table user01.user_tbl
add constraint const_01 unique (col01) 
using index tablespace user_tbs 
exceptions into user01.wrong_col01;

alter table user01.user_tbl
add constraint const_01 unique (col01) 
using index tablespace sys_tbs_disk_data 
parallel 4;

"Exceptions into" clauses causes Oracle to write to the
user01.wrong_col01 table information about any rows
currently in the user01.user_tbl table that violate the constraint.
ALTIBASE HDB also provides parallel clause.
But it only can be used during index creation.


We describe ALTIBASE HDB syntax  as compared with Oracle as below.

ALTIBASE HDB also provides inline constraint and out of line constraint regarding statement stated below. 

ORACLE

ALTIBAE HDB

Comments

NOT NULL

NOT NULL

 

UNIQUE

UNIQUE

 

PRIMARY KEY

PRIMARY KEY

 

FOREIGN KEY

FOREIGN KEY

 

CHECK


It will be provided in ALTIBASE HDB V7.

REF


 


ALTIBASE HDB does not support constraint statement as below.

  • DEFERRABLE
  • INITIALLY IMMEDIATE | DEFERRED
  • RELY | NORELY
  • ENABLE | DISABLE
  • EXCEPTIONS INTO

ALTIBASE HDB does not support VIEW Constraints.