Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 86938 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / vijay
1)Column level constraint is declared at the time of
creating a table but table level constraint is created
after table is created.
2)NOT NULL constraint can't be created at table level.
3)Composite primary key must be declared at table level.
4)All the constraints can be created at table level but for
table level NOT NULL is no allowed.
| Is This Answer Correct ? | 48 Yes | 25 No |
Post New Answer View All Answers
 How to use an oracle sequence generator in a mapping?
How to delete a column in an existing table in oracle?
What do you mean by merge in oracle and how can we merge two tables?
How to get last row id?
What is save point in oracle database?
Why does Oracle not permit the use of PCTUSED with indexes?
How do I uninstall oracle 11g?
How to execute the package in oracle?
Where are the settings stored for each instance in oracle?
How can we find out the current date and time in oracle?
How to upsert (update or insert into a table)?
How to find the duplicate rows count from employees table in oracle?
What is a oracle database?
How do I find the database name in oracle?
How to convert csv to table in oracle?
