oracle 日期处理
exec sql.
open c for
select TO_CHAR(zxbrq, 'YYYYMMDD:HH24:MI:SS') zxbrq,
zxbbh,zxbmc,zydrs,zqqrs,zjb,ztb,zxzrs,zxzqq,zxzjb,zxztb,zxzhj,zxbgs,orgeh,orgtx
from EDH.xbgssj
where to_char(zxbrq,'yyyy-mm-dd') = :lv_datum_sel
endexec.
取两张表不同的数据
SELECT
ZMM005.* ,
RSEG.WRBTR AS WRBTR2
FROM ZMM005
INNER JOIN RSEG ON RSEG.BELNR = ZMM005.BELNR AND RSEG.BUZEI = ZMM005.BUZEI
WHERE ZMM005.RBSTAT in ('A','5')
and EXISTs
(SELECT *
FROM RseG
WHERE RSEG.BELNR = ZMM005.BELNR AND RSEG.BUZEI = ZMM005.BUZEI
AND RSEG.WRBTR <> ZMM005.WRBTR)
多个字段要用逗号隔开,表和字段名必须大写
更新表数据(变量前加:)
exec sql.
update REPOLOAD set LDATA = :ls_REPOLOAD-ldata , qdata = :ls_REPOLOAD-qdata
where progname = :lv_progname
endexec.
exec sql.
commit
endexec.