Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87496 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pcsenthil
we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
How do you tell what your machine name is and what is its IP address?
defination of bitmap index
What is index-organized table in Oracle?
Why do we use coalesce function in oracle?
Why do you create or replace procedures rather that drop and recreate.
What is the difference between a hot backup and a cold backup in oracle?
Explain implicit cursor.
How to loop through data rows in the implicit cursor?
what is the scenario where you take the database to NoArchivelog mode?
How to start a new transaction in oracle?
What is the usage of merge statement?
How can I introduce multiple conditions in like operator?
How to get execution statistics reports on query statements?
What are the set operators union, union all, minus & intersect meant to do?
How to invoke the original export import utilities?
