这个语句能在plsql中运行么？
SELECT [PZTXH] 凭证体序号,DATEPART(yyyy,YHSKSJ) as 年度, DATEPART(mm,YHSKSJ) as 月,DATEPART(dd,YHSKSJ) as 日,
DWBM 单位编码,DWMC 执收单位名称,JKR 缴款人,JKSBH 缴款书编号 ,
XMBM 收费项目编码,XMMC 收费项目名称,SJJE 实际金额,YHSKSJ 银行收款时间,
SKRMC 收款人名称,SKRZH 收款人帐号,YHMC 收款人开户行名称,
JZBZ [记帐标志 1是 0否（默认）],
SJLY [数据来源 0待查确认 1正常收入 2退付 3收入调整 9结转旧数据]
--into 票据流水明细
FROM dbo.FSNEW_T_SRHS_PJLS order by YHSKSJ
要是不能，求说明，求改！
DWBM 单位编码,DWMC 执收单位名称,JKR 缴款人,JKSBH 缴款书编号 ,
XMBM 收费项目编码,XMMC 收费项目名称,SJJE 实际金额,YHSKSJ 银行收款时间,
SKRMC 收款人名称,SKRZH 收款人帐号,YHMC 收款人开户行名称,
JZBZ [记帐标志 1是 0否（默认）],
SJLY [数据来源 0待查确认 1正常收入 2退付 3收入调整 9结转旧数据]
--into 票据流水明细
FROM dbo.FSNEW_T_SRHS_PJLS order by YHSKSJ
要是不能，求说明，求改！
4同行回答
按照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收起
浏览880
兄弟，您这个是MS SQL的语句吧， PS/SQL for ms sql 版本应该可以执行收起
浏览799