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
- 14406 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 types of sql are there?
how to include character strings in sql statements? : Sql dba
Does google use sql?
What is the left table in sql?
What are all types of user defined functions?
Where is pl sql used?
Which constraints we can use while creating database in sql?
What is spool?
What is the difference between a query and a report?
How does sql store data?
What are the basic sql commands?
What do you think about pl/sql?
What is delimiter in pl sql?
what is a foreign key ? : Sql dba
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
