数据库导出数据到excel

1.先写一个sql语句，查出你需要的数据。

select pin,name,mobile,email from pp_customer c
where c.name is not null and c.email is not null
and c.pin is not null and c.mobile is not null and rownum < 2001

select  replace(pin,' ','') pin,replace(mobile,' ','') mobile,replace(email,' ','') email from pp_customer c where c.email is not null
and c.pin is not null and c.mobile is not null and rownum < 8001
and c.register_date between to_date('2007-01-01','yyyy-MM-dd') and to_date('2007-12-31','yyyy-MM-dd')

2.右键左上角的框，选择 copy to Excel

3。别忘了点这个。才能把数据都显示出来。