Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87389 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
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Describe varray?
What is the difference between a primary key & a unique key?
How different is ms access and oracle?
Is rowid unique in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is difference between truncate and delete?
What is a table index?
What is tns service name?
How to enter a new row into a table interactively?
How to update values on multiple rows in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How does the on-delete-cascade statement work?
how may join possible between (requisition with purchase order)
