Interested to Buy Any Domain ? << Click Here >> for more details...
If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
- 4 Answers
- 14252 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
Is clustered index a primary key?
Define sql delete statement.
Can we change the table name in sql?
What are all the different normalization?
What is varchar sql?
what is the difference between undefined value and null value? : Sql dba
What is #table in sql?
What is the difference between microsoft sql and mysql?
Why do you partition data?
What are different methods to trace the pl/sql code?
Explain what is a database?
What is pl sql in dbms?
what is the difference between primary key and unique key? : Sql dba
What are the uses of merge?
What are inner and outer joins examples of both?
