17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure p
(v_pid article.pid%type)
is
cursor c
is select * from article where pid = v_pid;
v_article c%rowtype;
begin
for v_article in c loop
dbms_output.put_line(v_article.cont);
if(v_article.isleaf = 0) then
p(v_article.id);
end if;
end loop;
end;
create or replace procedure p
(v_pid article.pid%type)
is
cursor c
is select * from article where pid = v_pid;
v_article c%rowtype;
begin
for v_article in c loop
dbms_output.put_line(v_article.cont);
end loop;
end;
create or replace procedure p
(v_pid article.pid%type)
is
cursor c
is select * from article where pid = v_pid;
v_article c%rowtype;
begin
for v_article in c loop
dbms_output.put_line(v_article.cont);
p(v_article.id);
end loop;
end;