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
14189 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

What is a subquery in oracle?

1098

What is where clause in oracle?

1020

What is the scope of a local variable?

1057

How to create a stored function in oracle?

1099

How to find the duplicate rows count from employees table in oracle?

1075

How to manage transaction isolation level?

996

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

1806

What are privileges and grants?

1063

What is raw datatype in oracle?

1125

what is insert all statement in sql

6498

What is an oracle function?

1148

What is the meaning of recursive hints in oracle?

1044

What are a query and state the different types of queries and their uses?

1010

What are the different types of trigger and explain its various uses and functions?

1082

Â What are the oracle DML commands possible through an update strategy?

1055