存储过程和函数：
例子：
//创建过程 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; |
