Because its a Column Level constraint. Not Null is a Constraint which will

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

Question Posted / lokanath

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

Please Help Members By Posting Answers For Below Questions

Explain oracle’s system global area (sga).

1074

how may join possible between (requisition with purchase order)

2167

Give the constructs of a package, function or a procedure.

982

Explain the use of analyse option in exp command.

1064

How to create id with auto_increment on oracle?

932

What is oracle database 10g express edition?

1070

What is a Garbage Collection? and what is full recursive Garbage collection?

2843

How to put more than 1000 values into an oracle in clause?

971

How to connect the oracle server as sysdba?

1009

Why oracle is used?

995

What operating systems are supported by oracle database 10g xe?

983

Explain what are the different type of segments?

912

Explain the blob datatype?

1013

What are operators in oracle?

1009

How to install oracle database 10g xe?

964