A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL BUT IT CAN BE A

why can't we assign not null constraint as table level
constraint

Question Posted / newton_dba

3 Answers
14024 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

Please Help Members By Posting Answers For Below Questions

How to recover a dropped table in oracle?

983

How to load a large xml file?

1001

When do we use group by clause in a sql query?

991

What happens to the current transaction if the session is ended?

1030

How to delete multiple rows from a table in oracle?

1002

What are the oracle differences between nvl and coalesce

1064

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

How can we find out the duplicate values in an oracle table?

992

What are the execution control statements in oracle?

1022

How does the on-delete-cascade statement work?

1058

What is index in Oracle?

1007

How to call a sub procedure?

1034

State and explain the different types of data models?

893

What are the different types of partitions in oracle?

907

Respected sir, Please send me technical questions related to oracle apps..

1759