dev

• 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;

mariashylaja

 Profile 

• Sep 18th, 2006

 

Hi,

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.

Regards,

Maria Antony Samy,

iNautix Technologies India Pvt ltd, Chennai.

Sathya

• 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;

Arun Kumar Pal

• Sep 19th, 2006

 

use where condition as

UPDATE <TABLE NAME> VALUE <VALUES> WHERE ROWNUM<=500

rashid

• Sep 20th, 2006

 

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

askvenki

 Profile Answers by askvenki 

• Jul 20th, 2007

 

hi guys i think rownum work only for at the time of select statement

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 8th, 2008

 

sql> update <table_name> set col_name='value' where rownum<=500;

Note: rowid will not work instead of rownum for updating the 500 records.