一select语句如下:
SELECT a.vcPlanCode, a.vcDeptName, a.vcGoodsName, a.fTotleMoney, a.vcStatus, a.vcOperator, a.dModifyDate,a.vcPlanID MainKey
FROM V_BUY_PLAN a
WHERE a.vcAspID='mulaolao' AND a.vcStatus <> '删除状态'
AND a.vcStatus <> '作废状态'
AND a.vcPlanID IN(SELECT vcPlanID FROM TB_BUY_PLAN_ITEM WHERE vcAspID='mulaolao' )
ORDER BY a.dCreateDate DESC;
在sql server中可以正确执行,但在oracle中就会出错,提示'操作将锁定,在活动操作之前不允许进行新的操作',我把'ORDER BY a.dCreateDate DESC'去掉后,该语句是可以执行的,请问大虾门'ORDER BY a.dCreateDate DESC'在oracle中怎么处理?
SELECT a.vcPlanCode, a.vcDeptName, a.vcGoodsName, a.fTotleMoney, a.vcStatus, a.vcOperator, a.dModifyDate,a.vcPlanID MainKey
FROM V_BUY_PLAN a
WHERE a.vcAspID='mulaolao' AND a.vcStatus <> '删除状态'
AND a.vcStatus <> '作废状态'
AND a.vcPlanID IN(SELECT vcPlanID FROM TB_BUY_PLAN_ITEM WHERE vcAspID='mulaolao' )
ORDER BY a.dCreateDate DESC;
在sql server中可以正确执行,但在oracle中就会出错,提示'操作将锁定,在活动操作之前不允许进行新的操作',我把'ORDER BY a.dCreateDate DESC'去掉后,该语句是可以执行的,请问大虾门'ORDER BY a.dCreateDate DESC'在oracle中怎么处理?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货