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
- 14575 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
How many databases can sql express handle?
What are the two types of exceptions in pl/sql?
How do I quit sql?
What are the parts of a sql statement?
What is ttitle and btitle?
What operators deal with null?
Is t sql a programming language?
how many groups of data types? : Sql dba
What is sql*plus?
What jobs use sql?
Difference between global and parameter variables?
What is a pl/sql block?
How do you truncate?
What type of database is sql?
What do you understand by case manipulation functions?
