无参数的存储过程
create procedure p_xsrbb()begin declare vp1 varchar(20); set vp1=4;select vp1 from dual;end;call p_xsrbb();
带输入参数的存储过程drop procedure if exists p_xsrbb;create procedure p_xsrbb(in vp2 int)begin declare vp1 varchar(20); set vp1=4;select vp2 from dual;end;call p_xsrbb(3434);
bitscn.com