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


Please Help Members By Posting Answers For Below Questions

How much memory your 10g xe server is using?

573


Explain the features of oracle?

586


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1651


What is Library Cache in Oracle?

633


How to define an anonymous procedure without variables?

539






What is meant by raw datatype?

554


How to add a new column to an existing table in oracle?

576


State the difference between a primary key and foreign key?

504


What do you mean by a deadlock?

507


How to view all columns in an existing table?

540


What do you mean by merge in oracle?

587


How to export data with a field delimiter?

571


How can you use check constraints for self referential integrity?

511


What is the difference between Delete, Truncate and Drop in Oracle?

594


How to display employee records who gets more salary than the average salary in the department?

584