No B'coz the sysdate contains date and time format

If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?

Question Posted / chandrasekar ramasamy

Answer Posted / chandrasekar ramasamy

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can get second highest salary in sql?

988

Enlist the advantages of sql.

1001

Can there be more than one function with a similar name in a pl/sql block?

985

How to process query result in pl/sql?

1128

How many joins can you have in sql?

937

What port does sql server use?

1061

What packages(if any) has oracle provided for use by developers?

5811

How can you know that statistics should be updated?

1079

Is left join inner or outer by default?

1019

How do I run a sql query?

1016

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1089

Why do we need cursors in pl sql?

1080

explain the advantages and disadvantages of stored procedure? : Sql dba

1009

Can we alter stored procedure?

987

What is an ndf file?

994