why can't we assign not null constraint as table level
constraint
- 3 Answers
- 13301 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
Can a formula column be obtained through a select statement ?
 How to use an oracle sequence generator in a mapping?
What is blob datatype?
What is the data pump import utility?
What is a server parameter file in oracle?
How to shutdown your 10g xe server?
How to calculate date and time differences in oracle?
How do I learn what codesets are available in oracle?
How do I know if oracle is installed on windows?
How to lock and unlock a user account in oracle?
What is ASM (Automatic Storage Management) in Oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Why is oracle database so popular?
What is Java Pool in Oracle?
what is dynamic SGA and static SGA
