why can't we assign not null constraint as table level
Answers were Sorted based on User's Feedback
Answer / 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|
Answer / 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|
Answer / newton_dba
A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL
BUT IT CAN BE APPLIED ON THE TABLE LEVEL BY USING ALTER
ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);
|Is This Answer Correct ?||7 Yes||13 No|
Difference between the “verify” and “feedback” command?
Explain 1st, 2nd, 3rd normalization form of data base
How to loop through a cursor variable?
How to import one table back from a dump file?
How to connect asp pages to oracle servers?
what is the difference between rollback & commit? can a foreign key has null value?
How to put more than 1000 values into an oracle in clause?
when i run my query on yesterday it is fast but today it is slow why?
Please explain joins in oracle?
What is the meaning of recursive hints in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to enter a new row into a table interactively?