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 / swapna

Answers were Sorted based on User's Feedback



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

Answer / madhuri

WHERE CURRENT OF clause is used to update the current row of
the active set of a cursor

Is This Answer Correct ?    11 Yes 1 No

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

Answer / swapna

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

Is This Answer Correct ?    10 Yes 2 No

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

Answer / vipul varshney

It allows to apply updates and deletes to the row currently
being addressed, without the need to explicitly reference
the ROWID.
You must include the FOR UPDATE clause in the cursor query
so that the rows are locked on OPEN.

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

Do ddl statements need commit?

0 Answers  

How to fetch alternate records from a table?

0 Answers  

Which sql statement is used to return only different values?

0 Answers  

What is dynamic query?

0 Answers  

What is pl sql record in oracle?

0 Answers  

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

How much does sql certification cost?

0 Answers  

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

How do I run a query in pl sql developer?

0 Answers  

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

What is a scalar value in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories