why can't we assign not null constraint as table level
constraint

Answer Posted / lokanath

Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.

Is This Answer Correct ?    10 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between primary key and unique key?

515


how to do daily transactions with out sql* loader control file regesterd in apps?

1222


What is a tns service name?

536


What types of joins are used in writing subqueries?

568


What is a partition in oracle?

545






What are the differences between lov and list item?

559


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

612


Explain parameter file in oracle.

579


How to use "in" parameter properly?

618


What are the limitations oracle database 10g xe?

572


What is an oracle tablespace?

608


What is the difference between a user and a schema in oracle?

562


Explain an extent?

659


What is the max number of columns in an oracle table?

513


What to do if the startbd.bat failed to start the xe instance?

611