04 2021 档案

摘要:如下: 国有银行,其他金融机构等分类; create or replace function fn_class_Bank_Super(bankname in varchar2) return varchar2 as begin if bankname like '中国农业银行%' then retu 阅读全文
posted @ 2021-04-23 15:07 xh_Blog 阅读(181) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2021-04-22 20:46 xh_Blog 阅读(244) 评论(0) 推荐(0) 编辑
摘要:如下: create or replace procedure testdate_2 is i number; out1 varchar2(100); out2 varchar2(100); CUSTOMERID NUMBER; cursor projidlist is select p.proji 阅读全文
posted @ 2021-04-21 16:55 xh_Blog 阅读(150) 评论(0) 推荐(0) 编辑
摘要:如下: select * from proj_baseinfo p where p.customername like 'xxx' or p.customername like 'yyy'; end; 阅读全文
posted @ 2021-04-01 11:30 xh_Blog 阅读(52) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示