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


Please Help Members By Posting Answers For Below Questions

What is a synonym? What are its various types?

891


What is the difference between count (*), count (expression), count (distinct expression)?

807


Can we commit inside a function in oracle?

752


What to do if the startbd.bat failed to start the xe instance?

854


How to use subqueries in the from clause in oracle?

858


Whats the benefit of dbms_stats over analyze?

1730


What is an Oracle index?

1425


What are the numeric comparison operations?

879


What happens to the data files if a tablespace is dropped?

826


What is an oracle?

778


How to use subqueries with the exists operator in oracle?

803


How to create a single index for multiple columns?

784


How to display employee records who gets more salary than the average salary in the department?

834


Define oracle database

813


What is an oracle user role?

804