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 |
What is dynamic proxy?
What do you understand by a database object? Can you list a few of them?
How do I uninstall oracle 11g?
which is the best training centre for learning oracle?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Please explain oracle data types with examples?
What are the different windows events activated at runtime ?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What is a nvl function? How can it be used?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Is rowid unique in oracle?
What is a lookup table in oracle?