touchmybody的专栏

select * from ( select * from table t where t.no='条件' order by t.iddesc ) C where rownum=1; insert into ri_i_inform select SEQ_RI_I_INFORM.nextval,t.ced_quote_no,t.ced_quote_endo_no,t.branch_code,t

范例： create or replace procedure test is v_count number(4); cursor v_c is select * from "t2VoucherHandNo"; begin select count(*) into v_count from "t2VoucherHandNo"; if

1、数据准备   表