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
- 14423 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 data modelling in sql?
Which is the correct statement about truncate and delete?
What is the use of double ampersand (&&) in sql queries? Give an example
Is big data nosql?
What is difference between sql and oracle?
What are pl/sql cursors?
What is an implicit commit?
What are its different types of dbms?
What is pl/sql table? Why is it used?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Does pdo prevent sql injection?
What is insert command in sql?
what does it mean to have quoted_identifier on? : Sql dba
How to convert comma separated string to array in pl/sql?
What is compiled query?
