FengxcLf的博客

MERGE INTO F_SHIPPINGORDER_GETBILL T1 USING(SELECT :SHIPPINGORDERKEY as SHIPPINGORDERKEY, :BATCHNO as BATCHNO,:SLID as SLID,:SLUSER as SLUSER,:SLDATE as SLDATE FROM dual) T2 ON(T1.SHIPPINGORDERKEY =...

public List<F_SEAFREIGHT> SeaFreightList(freight model){using (IDbConnection conn = GetConnection(DBType.Forwarder)){string query = “select * from F_SEAFREIGHT where TIMESTART <=sysdate...

select* from(select a.*,ROWNUM rn from(SELECT NVL(APPLYBILLID,‘0’) as APPLYBILLID, NVL(COMPLETEBILLID,‘0’) as COMPLETEBILLID, NVL(FDID,‘0’) as FDID,NVL(FDCONFIRMID,‘0’) as FDCONFIRMID,NVL(ZZVALUEID,...

CREATE OR REPLACE TRIGGER trg_shippingorder_getbill_hisAFTER UPDATEON F_SHIPPINGORDER_GETBILLFOR EACH ROWBEGINif updating(‘LQUSER’) thenINSERT INTO F_SHIPPINGORDER_GETBILL_HIS VALUES (:OLD.SHIPP...