Redian新闻
>
oracle的表名如何用变量代替
avatar
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?
avatar
B*g
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?

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。