I declare a varray and initialize it.
but always it says error.
'missing right parenthesis'
for i in 1..3 loop
select count(*) into n from patient(i);
end loop;
patient(i) is a varray I declared. how to change table name in a loop?
B*****g 发帖数: 34098
2
没看懂.
if patient(i) is just a table name like patient(i) = 'emp'
google "execute immediate"
【在 G***G 的大作中提到】 : I declare a varray and initialize it. : but always it says error. : 'missing right parenthesis' : for i in 1..3 loop : select count(*) into n from patient(i); : end loop; : patient(i) is a varray I declared. how to change table name in a loop?
