查询表的字段注解
select *
from user_col_comments co
where Table_Name='LC_APPL' and co.comments like'%自动%'
查询的 nvl函数和 分割函数 to_char
SELECT l.appl_seq,
lc.appl_ac_no,
case
when lc.appl_ac_kind = '01' then
'放款卡号'
when lc.appl_ac_kind = '02' then
'还款卡号'
end cardtype
FROM lc_appl l
join lc_appl_acc_info lc
on l.appl_seq = lc.appl_seq
where substr(nvl(l.last_chg_dt, to_char(sysdate - 1, 'yyyy-MM-dd')), 1, 10) =
to_char(sysdate, 'yyyy-MM-dd')
and lc.appl_ac_no is not null;