数据库导出数据到excel

最新推荐文章于 2024-09-29 08:44:52 发布

iteye_8330

最新推荐文章于 2024-09-29 08:44:52 发布

阅读量107

点赞数

分类专栏： oracle 文章标签：数据库

本文链接：https://blog.csdn.net/iteye_8330/article/details/82206701

版权

oracle 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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
[img]http://dl.iteye.com/upload/attachment/591040/67575994-e44f-32bb-b93b-1d93ac511bbb.gif[/img]
3。别忘了点这个。才能把数据都显示出来。
[img]http://dl.iteye.com/upload/attachment/591034/77696c80-4218-3ec9-ab1e-9ef265438cfc.jpg[/img]