oracle的sql的||代表+含义
SELECT A.TRADE_ID TRADEID,B.PROP_VALUE ORDERVALUE,B.TRADE_ID ORDERID, A.ROWID AS AROWID, B.ROWID BROWID
FROM T_DC_CB_BS_TRADE_DETAIL A,
T_DC_ORDER_CENTER_DETAIL B
WHERE B.PROP_VALUE LIKE '%'||A.TRADE_ID(+)||'%'
AND A.IMPORT_DATE = V_DDATE
AND A.IMPORT_DATE = B.IMPORT_DATE
oracle字段like
最新推荐文章于 2024-06-28 10:14:48 发布