1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

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

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

Answer / nagendra

Yes, it will validate the rows that are inserted with sysdate

Is This Answer Correct ?    9 Yes 3 No

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

Answer / zikku

No Date column can not validate the rows that are inserted
with sysdate.

Is This Answer Correct ?    5 Yes 3 No

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

Answer / chandrasekar ramasamy

No B'coz the sysdate contains date and time format

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How to run pl sql program in mysql?

0 Answers  

Can we use ddl commands in pl sql?

0 Answers  

What are the types of variable use in pl sql?

0 Answers  

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

What is the use of %rowtype?

0 Answers  




Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

In testing where do we use sql language and how it helps in testing?

2 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories