DEFERRABLE INITIALLY IMMEDIATE will check constraint violation after each statement being made
As you can see the constraint was fired twice – each time we inserted NULL values
You may also like
RR, YY and YYYY masks will interpret variable length years, means you can specify both two-digit or four-digit format as shown […]
NULL is not determinate value and is not counted when the COUNT function is used with the DISTINCT keyword For instance, if […]
Most likely you may have this situation on the exam. It is incomplete date format used with TO_DATE function. How will Oracle […]
Is it possible to use a Reserved Word as an alias? The answer is YES. But you need to double quote this […]