weixin_36944798的博客

type REFCURSOR is ref cursor;FUNCTION GET_HEART_RATE_NEXT_ID RETURN REFCURSOR;PROCEDURE PRO_Login(User_Name IN varchar2,Psw IN varchar2,Val OUT varchar2,Message OUT varchar2);FUNCTION GET_HE...

包头声明游标，存储过程type UPDATE_ID is ref cursor;PROCEDURE PRO_UPDATE_ID(User_Name_v IN varchar2);存储过程体：PROCEDURE PRO_UPDATE_ID(User_Name_v IN varchar2)ISCURSOR UPDATE_ID IS SELECT * FROM APP022...

外部工具中执行存储过程（调试一下该存储过程效果一样）EXEC APP022.APP_OXYGEN_PRO.PRO_UPDATE_ID(‘hellowhat’);存储过程中执行sqlstr:=‘select * from table’;EXECUTE IMMEDIATE STR;...

需要加数据库的目录下:G:\app\sinosoft\product\12.1.0\dbhome_1\BIN cmd命令框执行exp system/password@127.0.0.1/sinosoft file=d:\yjzygl.dmp owner=(yjzygl,other)exp yjzygl/password@127.0.0.1/sinosoft file=d:\yjzygl.d...