aq23es的博客

with temp as (select a.name as coaname, a.code, a.parent_code, a.is_leaf, b.pk_rm_prd, b.prdname, b.acct_prd, b.prin_pmt from (selec

create or replace procedure P_cfe_alm_ResSumTotal(pageNo in number,pageCount in number)is v_sql clob; ---自定义SQL语句 cfe_row cfe_alm_res_sum%ROWTYPE; cursor cfe_cursor is select * from cfe_al

create or replace procedure P_cfe_alm_ResSum_CoaLevel(i_pk_coa_set in char, i_pk_prd_set in char,

create or replace procedure P_cfe_alm_ResSum_Orgs(pk_org in char, innercode in char) is v_sql clob; ---自定义SQL语句 v_sql2 clob; pks VARC

create or replace procedure P_cfe_alm_ResSumTotal_Orgs2 isbegin insert into cfe_alm_res_sum_orgs ( PK_ALM_RES_SUM_ORGS, ACCT_PRD, asst_liab, bl_code, branch_code,

create or replace procedure clearPksTable(tableName in char) is v_sql clob;begin v_sql:= 'truncate table '||tableName||''; dbms_output.put_line(v_sql); execute immediate v_sql;end clearPksT

AMORT_DATE:=to_char(add_months(to_date(myemp.Pmt_dt,'yyyy-mm-dd'),-1),'yyyy-mm-dd');--日期减一个月declare -- Local variables here myemp rm_ftprate_res%ROWTYPE; --myemp 定义为表名为rm_ftprate_res的一行数据ROWTYPE cursor c_job ---通过一定条件限定的表名为rm_ftprate_res的数据集。游标