摘要: 1.字符串拼接update tbl_main d set d.area_id='0'||d.area_id2.存储过程及游标create or replace procedure PRC_INSET_DEALasbegin declare cursor main_depart is select * from main_bak ; temp main_bak%rowtype; begin open main_depart; loop fetch main_depart into temp; exit when main_depart%notfound; insert into 阅读全文
posted @ 2012-06-02 17:26 残星 阅读(264) 评论(0) 推荐(0) 编辑