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 convert characters to numbers in oracle?
What is a proxy class?
How index is implemented in oracle database?
How to invoke the data pump export utility?
How to join two tables in a single query using oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Why is oracle database so popular?
What is oracle open database communication (odbc)?
How to create a testing table in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is open database communication (odbc) in oracle?
What do you mean by a deadlock?
how can we store any pdf file in oracle
What is a database table in oracle?
What is the sid in oracle?