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


Please Help Members By Posting Answers For Below Questions

What is recovery manager(rman) backup in Oracle?

863


Explain joins in oracle?

758


What do you mean by merge in oracle?

757


Can we protect our pl/sql source code?

776


What do you mean by a deadlock?

735


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4874


What happens if the update subquery returns multiple rows?

798


How to declare a local variable?

806


Explain the use of constraints option in exp command.

766


master table and child table performances and comparisons in Oracle ?

1886


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2030


What is oracle instant client?

750


What is Trigger in Oracle?

785


What is the meaning of recursive hints in oracle?

751


How are extents allocated to a segment?

776