why can't we assign not null constraint as table level
constraint
Answer Posted / senthil
not null constraint applied on table level constraint but table must be empty otherwise not possible .
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How much memory your 10g xe server is using?
Explain the features of oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is Library Cache in Oracle?
How to define an anonymous procedure without variables?
What is meant by raw datatype?
How to add a new column to an existing table in oracle?
State the difference between a primary key and foreign key?
What do you mean by a deadlock?
How to view all columns in an existing table?
What do you mean by merge in oracle?
How to export data with a field delimiter?
How can you use check constraints for self referential integrity?
What is the difference between Delete, Truncate and Drop in Oracle?
How to display employee records who gets more salary than the average salary in the department?