摘要: 不带参数的存储过程 定义create procedure pro_goodsasbegin update goods set remark = 'sss' where goodsid = 1;end; 执行begin pro_goods;end; 使用游标的存储过程select * from goods where goodsid = 1create or replace procedure pro_goods_cursoras v_goodsinfo goods%rowtype; cursor cursor_goods is s... 阅读全文
posted @ 2012-04-16 22:52 shuaisam 阅读(217) 评论(0) 推荐(0) 编辑