why can't we assign not null constraint as table level
constraint
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
TABLE STATMENT
ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);
Is This Answer Correct ? | 7 Yes | 13 No |
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is a data lock in oracle?
How to omit columns with default values in insert statement in oracle?
What happens to the indexes if a table is recovered?
How much memory your 10g xe server is using?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are the uses of linked server and explain it in detail?
How many types of auditing in Oracle?
What is the sid in oracle?
How to define an anonymous block?
How many types of cluster table in Oracle?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example