oracle分页，导出，导入功能

oracle 分页SQL语句

SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_comment   where 
ne_products_id =2 and (ne_status_id=1 or ne_status_id=3)
order by ne_comment.ne_time desc) A) WHERE RN BETWEEN 1 AND 20

 

oracle 导出数据库

exp newegg/newegg@localhost/oracle11  file=D:\newegg.dmp tables=(comment_status,ne_comment,ne_order_father,ne_order_son,ne_plan_order,ne_products,ne_user,order_father_status,plan_order_status,products_brand,products_classify,products_content,products_images,products_status,user_level)

 

oracle 导入数据库

imp newegg/newegg@localhost/oracle11 file=D:\newegg.dmp full=y