why can't we assign not null constraint as table level
constraint
Answer Posted / lokanath
Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.
Is This Answer Correct ? | 10 Yes | 12 No |
Post New Answer View All Answers
Explain the use of online redo log files in oracle.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to convert dates to characters in oracle?
Where is the export dump file located?
What is enter substitution variable in oracle?
What are the different types of failures that occur in Oracle database?
What is a system tablespace?
What are triggers in oracle?
What is an oracle database?
Is oracle the best database?
Explain the use of control file?
How do I find the database name in oracle?
What is data file?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What to do if the binary spfile is wrong for the default instance?