ORA-00933是什么问题
请问下,谁知道我这句SQL语句的问题在哪吗.我在ORACLE上执行就出现ORA-00933: SQL command not properly ended,
谁能帮我纠正下错在哪里吗.
谢谢大家了.比较急
select * from (select calling_range_id,range_type_id,region_info_id,switch_info_id,calling_begin,calling_end,description from calling_range
where region_info_id='1' and switch_info_id='244' order by region_info_id,range_type_id) as callingRange_tbl limit 0 , 20
错误:ORA-00933: SQL command not properly ended
[解决办法]
oracle分页不用 limit 0 , 20 的，你把它改成
select * from (select calling_range_id,range_type_id,region_info_id,switch_info_id,calling_begin,calling_end,description,rownum rn from calling_range
where region_info_id='1' and switch_info_id='244' order by region_info_id,range_type_id) as callingRange_tbl where rn>0 and rn<=20
