select ttt.updated_date,
ttt.plan_code,
ttt.risk_level,
ttt.treaty_no,
ttt.indemnity_limit_type,
ttt.indemnity_limit,
(ttt.risk_class_code)风险等级代码,
ttt.id_rims_treaty_prop_section
from rims_treaty_prop_coverage_t ttt
where ttt.updated_date >= sysdate -1 and ttt.plan_code = 'B01'
union
select * from rims_treaty_prop_risk_info_t