04 2021 档案
摘要:如下: 国有银行,其他金融机构等分类; create or replace function fn_class_Bank_Super(bankname in varchar2) return varchar2 as begin if bankname like '中国农业银行%' then retu
阅读全文
摘要:case (select pe.EXINFOVALUE from PROJ_EXINFO pe where pe.projid=p.PROJID AND pe.EXINFOCODE='isMultiBank') when '0' then case when p.LOANBANKNAME like
阅读全文
摘要:如下: create or replace procedure testdate_2 is i number; out1 varchar2(100); out2 varchar2(100); CUSTOMERID NUMBER; cursor projidlist is select p.proji
阅读全文
摘要:如下: select * from proj_baseinfo p where p.customername like 'xxx' or p.customername like 'yyy'; end;
阅读全文