17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace function fun_test(iBook_name in varchar2)
return int
is
vCount int;
begin
select count(1)
into vCount
from course
where cou_name = iBook_name;
if ( vCount = 1 ) then
return 1;
else
return 0;
end if;
end;
create or replace function fun_test(iBook_name in varchar2)
is
vCount int;
begin
select count(1)
into vCount
from course
where cou_name = iBook_name;
if ( vCount = 1 ) then
return 1;
else
return 0;
end if;
end;
declare
v_result varchar2(32767) := '';
cursor v_cur is select ENAME from scott.emp;
v_ename varchar2(50);
begin
open v_cur;
loop
fetch v_cur into v_ename;
exit when v_cur%notfound;
v_result := v_result||v_ename||'--';
end loop;
dbms_output.put_line(rtrim(v_result,'--'));
end ;
上面这段可以直接在SQLPLUS下执行
create or replace function f_list_ename
return varchar2 is
v_result varchar2(32767) := '';
cursor v_cur is select ENAME from scott.emp;
v_ename varchar2(50);
begin
open v_cur;
loop
fetch v_cur into v_ename;
exit when v_cur%notfound;
v_result := v_result||v_ename||'--';
end loop;
return(rtrim(v_result,'--'));
end f_list_ename;
写了一个较简单的,仅供参考。