![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
小码农的大梦想
这个作者很懒,什么都没留下…
展开
-
Oracle数据库匹配条件更新和新增
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 =...原创 2019-07-02 08:48:22 · 912 阅读 · 0 评论 -
条件查询注意
public List<F_SEAFREIGHT> SeaFreightList(freight model){using (IDbConnection conn = GetConnection(DBType.Forwarder)){string query = “select * from F_SEAFREIGHT where TIMESTART <=sysdate...原创 2019-07-08 09:19:34 · 153 阅读 · 0 评论 -
oracle分页语句
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,...原创 2019-07-03 10:05:39 · 298 阅读 · 0 评论 -
触发器FOR EACH ROW行触发器
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...原创 2019-07-17 16:28:31 · 1713 阅读 · 0 评论