why can't we assign not null constraint as table level
constraint
Answer Posted / senthil
not null constraint applied on table level constraint but table must be empty otherwise not possible .
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to convert numbers to characters in oracle?
Can we commit inside a function in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Difference between pre-select and pre-query
Explain the blob datatype?
Which is faster join or subquery in oracle?
 How to use an oracle sequence generator in a mapping?
What privilege is needed for a user to connect to oracle server?
Can you have more than one content canvas view attached with a window ?
How to add another datafile to a tablespace?
what are actual and formal parameters?
What is a private synonym?
How to convert characters to numbers in oracle?
How does Oracle guarantee data integrity of data changes?