Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain the usage of WHERE CURRENT OF clause in cursors ?

Question Posted / guest

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

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

why we use nocopy?

2 Answers   Polaris,

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

What is rtm stands for?

0 Answers  

Can I join the same table twice?

0 Answers  

Explain the update statement in sql

0 Answers  

What is sql key?

0 Answers  

what is the difference between sql and t-sql? : Transact sql

0 Answers  

What does count (*) do in sql?

0 Answers  

Why sql query is slow?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories