What is the difference between column level constraints and
table level constraints?
Answer Posted / riddhi
Difference between column level constraints and table level constraints
1)Column level constraint is declared at the time of creating a table but table level constraint is created after table is created.
2)Column Level Constraints refers Only One Column whereas table level constraints refers to one or more than one column
3)not null constraint can't be created as table level constraints because it don't have name.
Column level constraint-
Ex : Create table emp
( empno number primary Key);
Table level constraint
Ex: Create table emp
( empno number);
Constraints pk_con primary Key(empno));
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a synonym? What are its various types?
What is the difference between count (*), count (expression), count (distinct expression)?
Can we commit inside a function in oracle?
What to do if the startbd.bat failed to start the xe instance?
How to use subqueries in the from clause in oracle?
Whats the benefit of dbms_stats over analyze?
What is an Oracle index?
What are the numeric comparison operations?
What happens to the data files if a tablespace is dropped?
What is an oracle?
How to use subqueries with the exists operator in oracle?
How to create a single index for multiple columns?
How to display employee records who gets more salary than the average salary in the department?
Define oracle database
What is an oracle user role?