If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
- 4 Answers
- 13640 Views
- I also Faced
- E-Mail Answers
Answer Posted / kangana
uNIQUE CONSTARINT CAN VALIDATE PSEUDOCLOUMN SYSDATE
SYSDATE FORMAT IS LIKE 3/2/2010 8:42:46 PM
SO FOR EACH MILLISECOND IF U INSER A ROW IT WILL TAKE THE
INSERTION BUT IF U INSERT IN EACH FRACTION OF MILLISECOND
ITS VALIDATE AND UNIQUE CONSTARINT IS VOILATED.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is information schema in sql?
is it possible to pass an object or table to a procedure as an argument?
What are sql indexes?
What is difference between ms sql and mysql?
what is column? : Sql dba
what is rdbms? : Sql dba
Can a procedure in a package be overloaded?
What is the difference between microsoft access and sql?
What is field delimiter?
Is sql a backend language?
What is an alias command?
Is sql the best database?
Explain mutating table error.
What is a string data type in sql?
Why functions are used in sql?
