Hi
I want to update multiple columns from emp_test with columns from hremp3 table. And, my sample sql is as below. I am not sure I can write like this as error keep showing ORA00927 missing equal sign in line 17 column 30. Please advise .
Thank you
declare
cursor c_data IS
select fname,lname FROM EMP_TEST;
type emparray is varray(2) of varchar2(10);
type hremparray is varray(2) of varchar2(10);
emp emparray;
hremp hremparray;
BEGIN
emp := emparray('fname',' lname');
hremp := hremparray('fname','lname');
FOR i in 1 .. c_data LOOP
update emp_test set emp(i) =hremp3. hremp(i) where emp_test.emplid=hremp3.emplidhr;
END LOOP;
END;