本文共 603 字,大约阅读时间需要 2 分钟。
过程和函数:
例子:
//创建过程 create or replace procedure add_emailinfo(namee email_info.fullname%type ,address email_info.email_address%type ) is begin insert into email_info(fullname,email_address) values (namee,address); end; //调用过程 call add_emailinfo('cherry','asdfsdf'); / //创建函数 create or replace function sel_emailinfo(namee email_info.fullname%type ) return varchar2 is address varchar2(30); begin select email_address into address from email_info where trim(fullname)=trim(namee); return address; end ; //调用函数 select sel_emailinfo('bbb') from dual;
转载地址:http://szkli.baihongyu.com/