SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

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

SQL Interview Question
SQL Interview Question

Answer:

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

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?