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

Store procedure will return a value?

4 Answers   eMids,

How will you a activate/deactivate integrity constraints?

2 Answers  

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

What is sql and also describe types of sql statements?

0 Answers  

explain access control lists. : Sql dba

0 Answers  

How do you write an inner join query?

0 Answers  

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

What is the use of partition by in sql?

0 Answers  

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

What are system versioned tables?

0 Answers  

How global cursor can be declare with dynamic trigger ?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories