What is the difference between column level constraints and
table level constraints?
Answer Posted / rajan sharma
Column level are those constraints that are inserted after
the declaration of the data typeot
Syntax :
CREATE TABLE table_name
(Column_name Datatype NOT NULL )
Example : Not null,pimary key,foreign key, unique and check.
Table level constraints are those that are inserted at the
end of the table.
Example : pimary key,foreign key, unique and check.
Thanks
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What is oracle server autotrace in oracle?
How are extents allocated to a segment?
What are the limitations oracle database 10g xe?
State the various uses of dbcc command?
What are the built-in functions used for sending Parameters to forms ?
master table and child table performances and comparisons in Oracle ?
Give the various rollback segment states.
What is difference between truncate and delete?
How to call a stored function with parameters?
How to best split csv strings in oracle 9i?
What are the execution control statements?
How to change program global area (pga) in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
What is a proxy object?
How to connect ms access to oracle servers?