Oracle中的常用函数

1：nvl（）

select c.credit_evaluate_id, c.a8_flow_id
from crd_credit_evaluate c
where c.a8_flow_id is not null
and c.status = :status
and nvl(c.ATTRIBUTE1,00)<> :attribute1

 

 

comment on column BAS_CONTRACT.PARTY_CODE is '客户供应商编码';

 

 

2：字段合并

select u_id, wmsys.wm_concat(goods || '(' || num || '斤)' ) goods_sum   from shopping   group by u_id