How to call function and procedure - Jcat

首页新随笔新文章联系聚合

posts - 173,comments - 67,trackbacks - 0

Background

create or replace function f_must_return(hello in varchar2 ) return varchar2 is

Result varchar2 ( 20 );

begin

Result : = hello || ' world ' ;

return (Result);

end f_must_return;

调用函数

-- by select

select f_must_return( ' hello ' ) from dual;

-- by procedure exec

set serveroutput on ;

exec dbms_output.put_line(f_must_return( ' hello ' ))

-- by variable

variable x varchar2

exec :x: = f_must_return( ' hello ' )

posted on 2006-12-19 13:25 Jcat 阅读(182) 评论(0) 编辑收藏

随笔分类(171)