why can't we assign not null constraint as table level
constraint
- 3 Answers
- 12631 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 u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is an oracle and why it is used?
How to use in conditions in oracle?
Can we write insert statement in function in oracle?
What is set operator oracle?
Explain a synonym?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is pragma autonomous transaction in oracle?
What are the restrictions in a oracle read only transaction?
How to create an oracle database?
What are the benefits of ordbms?
What happens if you lost a data file?
What is snapshot is too old? Give and example for better understand.
How do I start tns listener?
What is an oracle cursor variable?
