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||12 No|
why dont we assign not null constraint as table level constraint.
Calculate difference between 2 date / times in oracle sql?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What are the different type of Segments ?
What is the difference between SQL and SQL Server?
How to sort output in descending order in oracle?
What's dateware house and what's clustor with practicle example
How to store only time; not date and time?
What are the differences between char and varchar2 in oracle?
Explain 1st, 2nd, 3rd normalization form of data base
what is unique key?
Explain the relationship among Database, Tablespace and Data file?