oracle字段like

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