oracle的表名如何用变量代替# Database - 数据库
G*G
1 楼
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?
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?