PL/SQL cursor question

From: Klaas Talsma <kltalsma_at_xs4all.nl>
Date: Mon, 08 Jan 2001 17:15:39 GMT
Message-ID: <3a59f4b7.8039043@news.xs4all.nl>

I need to achieve the following

using a cursor i need to update a table wich stores employee's and their salary, now i need to know how,

the salary's up to 2000 need to by updated by 8%

,,        ..      from 2000 to 2500 need to be updated by 6%
,,        ,,         ,,   2500 to 3500    ,,     ,,  ,,  updated by 4%

and from 3500 and above updated by 2%

i have no clue what so ever to do this with a cursor

i'm able to do this with normal SQL but know i would like to know how to achieve this with a cursor

can someone help me?

grtnx,

Klaas Talsma Received on Mon Jan 08 2001 - 11:15:39 CST