AshwaDip Tutorials

1. Oracle
2. Fundamentals of DB
3. SQL
4. SQL LANGUAGES
5. CONSTRAINTS
6. OPERATORS
7. JOINS
8. SUB - QUERIES
9. DB OBJECTS
10. PARTITIONS
11. FUNCTIONS
12. PL/SQL
13. PLSQL Interview

4. DATA INTEGRITY CONSTRAINTS

• KEY Constraints
• DOMAIN Constraints
• REFERENTIAL INTEGRITY Constraints

1. NOT NULL
2. UNIQUE
3. PRIMARY KEY
4. FOREIGN KEY Constraints
5. CHECK Constraint.
6. REF constraint

ALTER TABLE OMC_CUSTOMER_CARD
ADD CONSTRAINT RC_NUMBER_UNIQUE UNIQUE (RC_NUMBER);
ALTER TABLE supplier
ADD CONSTRAINT supplier_pk PRIMARY KEY (supplier_id);
alter table contactable_customer_answer add constraint DEFAULT_YN check (ANSWER in ('Y','N'));