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
What is the usage of synonyms?
What to do if dba lost the system password?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What the is the diff between local index and global index. give some example.
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What happens if the update subquery returns multiple rows?
How does the on-delete-cascade statement work?
What is the maximum number of triggers that can be applied to a single table?
what is the difference between substr and instr function in oracle?
How to create a table in a specific tablespace?
What are named parameters?
What are the general rules on data consistency?
Define oracle database
What are the original export and import utilities?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database