Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14194 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 |
How to change user password in oracle?
7. Repeat query (7) but also display all clients who have never ordered anything.
How to filter out duplications in the returning rows using oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is cluster Key ?
How to use "if" statements on multiple conditions?
What is the difference between sharding and partitioning?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
How do I know if oracle is installed on windows?
How does one get the view definition of fixed views/tables?
What is oracle database client?
Oracle General 
