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
- 14467 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 sql a dbms?
What is sql scripting?
Explain the uses of database trigger.
What are stuff and replace function?
How do I count rows in sql?
Why is sharding used?
How to disable a trigger name update_salary?
What is sql constant?
What is string data type in sql?
How many disk partitions should I have?
How many sectors are in a partition?
What is sqlerrd?
What is the size of partition table?
What is sql character function?
What is meaning of <> in sql?
