What is the difference between column level constraints and
table level constraints?
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 to store pictures on to the database?
What are the extensions used by oracle reports?
How do I escape a reserved word in oracle?
how can we store any pdf file in oracle
How would you begin to troubleshoot an ORA-3113 error?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is ASM (Automatic Storage Management) in Oracle?
How to use an explicit cursor without open statements?
Explain an exception?
What is the exact use of Collections?
What is format trigger?
ABOUT IDENTITY?
What is ordinary table in oracle?
Can we protect our pl/sql source code?
How to create a new user account in oracle?