1)any one can tell me,suppose we have 1000 of records,ok.then we want to update only 500 records,how can we solve this problem?2)how many types of "explicit cursors" we have?

Showing Answers 1 - 7 of 7 Answers


  • Sep 18th, 2006

I think u have to specify the condition while u creating a cursor like:

cursor c1 is select * from employee where sal>3000;

  Was this answer useful?  Yes


  • Sep 18th, 2006


For your First question


Why can't you use the update clause to accomplish your task?

Why can't you restrict the no of rows being updated using a where clause in the normal Update statement?


For the next question


All the cursors that you explicitly declare come into the "Explicit Cursor" family. This includes, Normal explicit cursor, Parameterized cursor, for loop cursor or technically a ref cursor can also be called as a explicit cursor though that is described seperately as "REF Cursor" by Oracle users.


Please do not hesitate to ask us again if you have anything to ask.


Maria Antony Samy,

iNautix Technologies India Pvt ltd, Chennai.


  • Sep 19th, 2006

I think, we can use update command based on the rowid of that particular column for ex:

Update Tablename set columnname=value where rowid<=500;

  Was this answer useful?  Yes

Arun Kumar Pal

  • Sep 19th, 2006

use where condition as



  • Sep 20th, 2006

update <t.name> set <col.name>=<values> where rownum <500;

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions