DEVFYI - Developer Resource - FYI

If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

PL/SQL Interview Questions and Answers


(Continued from previous question...)

If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

It won't, Because SYSDATE format contains time attached with it.

(Continued on next question...)

Other Interview Questions