DEVFYI - Developer Resource - FYI

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

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

573. If an 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