If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
Answer Posted / chandrasekar ramasamy
No B'coz the sysdate contains date and time format
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
what is a table in a database ? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How can a function retun more than one value in oracle with proper example?
What is difference between stored procedures and application procedures?
What are the ddl commands?
What is the difference between python and sql?
What do you mean by dbms? What are its different types?
What is a string data type in sql?
Explain dml and ddl?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Can we use insert statement in function?
how to increment dates by 1 in mysql? : Sql dba
Which is faster union or join?
what are the t string functions available in tsql? : Transact sql