w1506352784
Mart1n_
2016-09-22 06:10
采纳率: 100%
浏览 1.4k
已采纳

SQLSyntaxErrorException: ORA-00907: 缺失右括号

select * from ( select a.*, ROWNUM rnum from ( select site_code,shop_order,target_qty,start_date,close_date,sales_order,customer_code,item_code,status ,remark,create_by,create_time,update_by,update_time from SHOP_ORDER WHERE shop_order = ? and start_date between to_date(?,'yyyy/mm/dd hh24:mi:ss') and close_date between to_date(?,'yyyy/mm/dd hh24:mi:ss') and status = ? ) a where ROWNUM < ?) where rnum >= ?

大神大牛帮帮忙。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • seeze
    Zedee 2016-09-22 06:19
    已采纳

    between...and又写错了
    start_date between to_date(?,'yyyy/mm/dd hh24:mi:ss') and to_date(?,'yyyy/mm/dd hh24:mi:ss')

    点赞 评论

相关推荐