3,490
社区成员
发帖
与我相关
我的任务
分享
begin
<<inner1>>
select count(*) from t_test a, t_test b where a.aid=b.aid;
end inner1;
写成如下吧:在plsql里面的command模式窗口下执行
declare
v_c number;
begin
begin
<<inner1>>
select count(*) into v_c from t_customer t, t_customer_tel;
end inner1;
dbms_output.put_line(v_c);
end;
/
declare
begin
<<inner1>>
select count(*) from t_test a, t_test b where a.aid=b.aid;
end inner1;