If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
- 4 Answers
- 13037 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
Are dml statements autocommit?
Is natural join and inner join same?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is sql stand for?
what is bcp? When is it used?
What are all the different normalization?
Can you have more than one key in a database?
Is sql dba a good career? : SQL DBA
How to get list of all tables from a database?
What is scope and visibility in PL/SQL?
Is sql sequential or random?
How can we store rows in PL/SQL using array?
What is pessimistic concurrency control? : Transact sql
What are the different sql commands?
What is an ndf file?
