摘要:
1.分页查询select * from (select rownum no, e.* from (select * from emp order by sal desc) e where rownum<=5 ) where no>=3select * from (select rownum no,e.* from (select * from emp order by sal desc) e) where no>=3 and no<=52.存储过程a.范例一create or replace procedure bp_sp_product_insert( v_produ 阅读全文