Oracle Stored Procedures

--Build TableCreate TableXuesheng (IDinteger, xing_mingvarchar2( -), Yu_wen Number, Shu_xue Number);Insert  intoXueshengValues(1,'Zhangsan', the, -);Insert  intoXueshengValues(2,'Lisi', -, the);Select *  fromXuesheng;--Create a first stored procedureCreate or Replace procedureXs_proc_no isbegin       Insert  intoXueshengValues(3,'Wangxu', -, -);Commit;EndXs_proc_no;--Create a second stored procedureCreate or Replace procedureXs_proc (temp_nameinch varchar2, Temp_num out Number) isnum_1 Number; Num_2 Number;begin      SelectYu_wen,shu_xue intonum_1,num_2 fromXueshengwhereXing_ming=Temp_name; Temp_num:=Num_1+num_2;End;--Creating CursorsCreate or ReplacePackage MyPackage astype My_cursor isRefcursor;EndMyPackage;--Create a third stored procedureCreate or Replace procedureXs_proc_list (Shuxueinch  Number, p_cursor out Mypackage.my_cursor) isbegin  OpenP_cursor for    Select *  fromXueshengwhereShu_xue>Shuxue;EndXs_proc_list;

MyEclipse Test

Http://pan.baidu.com/s/1eQ7qSH8