数据库导出数据到excel

原创于 2011-11-18 17:07:25 发布 · 138 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

oracle 专栏收录该内容

6 篇文章

订阅专栏

本文介绍如何使用SQL语句从数据库中筛选特定数据，并将其导出至Excel表格，具体步骤包括：编写SQL查询语句以过滤条件；执行查询并查看结果预览；选择将数据导出至Excel的功能；确保所有数据正确显示于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
[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]