Explain the usage of WHERE CURRENT OF clause in cursors ?

Question Posted / guest

4 Answers
14489 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / tulsi

WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.

Is This Answer Correct ?

19 Yes

2 No

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / rahul koshti

By using WHERE CURRENT OF clause you can update or delete
records from the table where CURSOR fetched the records. But
for this you MUST have to open cursor with the clause of
'FOR UPDATE [OF COLUMN_NAME]'.

Is This Answer Correct ?

7 Yes

1 No

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / nishi

WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

Is This Answer Correct ?

2 Yes

0 No

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / amar_kondla

wherecurrent of clause means which is currently being modify
by the view,where not on dml

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

Can we use ddl statements in stored procedure sql server?

0 Answers

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers

what are the different tables present in mysql? : Sql dba

0 Answers

What is count * in sql?

0 Answers

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

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,

How to make a copy values from one column to another in sql?

0 Answers

Difference between SUBSTR and INSTR?

3 Answers

What are the sql commands?

0 Answers

What is clustered index sql?

0 Answers

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers Tech Mahindra,

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers

For more SQL PLSQL Interview Questions Click Here