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

Explain the use of online redo log files in oracle.

569


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1453


How to convert dates to characters in oracle?

568


Where is the export dump file located?

561


What is enter substitution variable in oracle?

555






What are the different types of failures that occur in Oracle database?

583


What is a system tablespace?

584


What are triggers in oracle?

548


What is an oracle database?

602


Is oracle the best database?

505


Explain the use of control file?

643


How do I find the database name in oracle?

588


What is data file?

600


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1569


What to do if the binary spfile is wrong for the default instance?

551