Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14028 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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 the difference between a primary key & a unique key?
What would you do if a database crashes in production?
What is ceil and floor in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is raw datatype?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
what is the difference between simple view and complex view?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
What is a table index in oracle?
what is the bitmap index?
How to define a cusotmer as a supplier in ORACLE R12
Oracle General 
