Hi Tom,

I have table called customers with data below

SQL> select * from customers;

ID NAME AGE ADDRESS SALARY
---------- -------------------- ---------- -------------------------------------------------- ----------
1 Ramesh 35 Ahamedabad 2000
2 Khilan 25 Delhi 1500
3 Kaushik 23 Kota 2000
4 Chaithali 25 Mumbai 6500
5 Hardik 27 Bhoopal 8500
6 Kamal 22 MadhyaPradesh 4500
7 Muffy 24 Indore 10000
8 Md Rafi 31 UttarPradesh 1500
9 Gajanana 30 karnataka 45000

No i need to increment salary of all the employees

code here


SQL> declare
2 type aat is table of number index by pls_integer;
3 vtemp aat;
4 begin
5 select *
6 bulk collect into vtemp
7 from customers;
8 forall i in 1..vtemp.last
9 update customers set salary=salary+200
10 where salary=vtemp(i);
11 end;
12 /
from customers;
*
ERROR at line 7:
ORA-06550: line 6, column 25:
PL/SQL: ORA-00947: not enough values
ORA-06550: line 5, column 1:
PL/SQL: SQL Statement ignored


Need fix for this. Your help will be appreciated.

update customers set salary=salary+200

type aat is table of customers%rowtype index by pls_integer;