If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nagendra
Yes, it will validate the rows that are inserted with sysdate
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / zikku
No Date column can not validate the rows that are inserted
with sysdate.
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / chandrasekar ramasamy
No B'coz the sysdate contains date and time format
Is This Answer Correct ? | 5 Yes | 3 No |
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
What is the default value of CHAR type?
What are some emotional triggers?
How do I find duplicates in a single column in sql?
If a cursor is open, how can we find in a pl/sql block?
Is it possible for a table to have more than one foreign key?
What are records give examples?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is difference between stored procedure and trigger?
How do you go back in sql?
Explain isolation levels. : Transact sql
What is orm in sql?