这个语句能在plsql中运行么？
SELECT [PZTXH] 凭证体序号,DATEPART(yyyy,YHSKSJ) as 年度, DATEPART(mm,YHSKSJ) as 月,DATEPART(dd,YHSKSJ) as 日, DWBM 单位编码,DWMC 执收单位名称,JKR 缴款人,JKSBH 缴款书编号 , XMBM 收费项目编码,XMMC 收费项目名称,SJJE 实际...显示全部
查看其它 3 个回答liulei_oracle的回答
按照Oracle的规则修改了一下，
SELECT PZTXH as 凭证体序号,TO_CHAR(YHSKSJ,'yyyymmdd') AS "年月日"
DWBM as "单位编码",DWMC as "执收单位名称",JKR as "缴款人",JKSBH as "缴款书编号",
XMBM as "收费项目编码",XMMC as "收费项目名称",SJJE as "实际金额" ,YHSKSJ as "银行收款时间",
SKRMC as "收款人名称",SKRZH as "收款人帐号",YHMC "收款人开户行名称",
decode(JZBZ,1,'是',0,'否')
decode(SJLY,0,'待查确认',1,'正常收入',2,'退付',3,'收入调整',9,'结转旧数据')
--into 票据流水明细
FROM owner.FSNEW_T_SRHS_PJLS order by YHSKSJ
SELECT PZTXH as 凭证体序号,TO_CHAR(YHSKSJ,'yyyymmdd') AS "年月日"
DWBM as "单位编码",DWMC as "执收单位名称",JKR as "缴款人",JKSBH as "缴款书编号",
XMBM as "收费项目编码",XMMC as "收费项目名称",SJJE as "实际金额" ,YHSKSJ as "银行收款时间",
SKRMC as "收款人名称",SKRZH as "收款人帐号",YHMC "收款人开户行名称",
decode(JZBZ,1,'是',0,'否')
decode(SJLY,0,'待查确认',1,'正常收入',2,'退付',3,'收入调整',9,'结转旧数据')
--into 票据流水明细
FROM owner.FSNEW_T_SRHS_PJLS order by YHSKSJ
浏览891