Answer Posted / guest
integrity Constraints is used by oracle to check data
Integrity while performing operations into database.
Like columns is defined as not null.User cannot insert null
values into this column
Constraints:
1. Primary Key
2. Unique Key
3. Not Null
4. Referential Integrity(Foreign Key)
5.Check Constraints
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a subquery and a join?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Why truncate is faster than delete?
What is the difference between an inner and outer join?
How many types of cursors are available in pl/sql?
What is dml with example?
What is full join in sql?
Can we create table inside stored procedure?
What are the types pl/sql code blocks?
What is the use of index in hive?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the purpose of my sql?
What is oracle pl sql developer?
what are enums used for in mysql? : Sql dba
What are the commands used in sql?
