Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14216 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
What is a trace file and how is it created in oracle?
How to set up autotrace for a user account?
What is system global area (sga) in oracle?
How to write an inner join with the where clause in oracle?
Explain the use of rows option in exp command.
What is the difference between translate and replace in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to synchronize 2 schema's objects?
What is a table index in oracle?
What the is the diff between local index and global index. give some example.
How to get execution statistics reports on query statements?
What is a cursor variable?
What is concurrency in oracle?
What is Data Dictionary Cache in Oracle?
