What is the difference between column level constraints and
table level constraints?
Answer Posted / akki
column constraint is only for particular column to provide restriction,
where in table level constraint we define multiple constraint at same time except not null .
not null is only used for column level.
ex: create table customer(cust_id number(2) not null,cust_name varchar2(20)check(cust_name like 'C%');
above example is shows constraints on column level.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is an oracle database?
How can we create the complete backup of data in the oracle.
Difference between pre-select and pre-query
What happens if variable names collide with table/column names?
What are the uses of Database Trigger ?
What is snapshot is too old? Give and example for better understand.
Why does for update in oracle 8 cause an ora-01002 error?
Whether any commands are used for months calculation? If so, what are they?
What are the components of logical database structure in oracle database?
What is max rowid in oracle?
What is the usage of control file in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is user managed backup in Oracle?
Explain a synonym?
How to get execution statistics reports on query statements?