http://blog.csdn.net/picture_1230/archive/2008/02/25/2118217.aspx PL/SQL   can   do   it,   it   might   look   like: 

create   or   replace   function     dump_csv(   p_query           in   varchar2, 
                                                                            p_separator   in   varchar2 
                                                                                                        default   ', ', 
                                                                            p_dir               in   varchar2   , 
                                                                            p_filename     in   varchar2   ) 
return   number 
AUTHID   CURRENT_USER 
is 
        l_output                 utl_file.file_type; 
        l_theCursor           integer   default   dbms_sql.open_cursor; 
        l_columnValue       varchar2(2000); 
        l_status                 integer; 
        l_colCnt                 number   default   0; 
        l_separator           varchar2(10)   default   ' '; 
        l_cnt                       number   default   0; 
begin 
        l_output   :=   utl_file.fopen(   p_dir,   p_filename,   'w '   ); 

        dbms_sql.parse(     l_theCursor,     p_query,   dbms_sql.native   ); 

        for   i   in   1   ..   255   loop 
                begin 
                        dbms_sql.define_column(   l_theCursor,   i, 
                                                                        l_columnValue,   2000   ); 
                        l_colCnt   :=   i; 
                exception 
                        when   others   then 
                                if   (   sqlcode   =   -1007   )   then   exit; 
                                else 
                                        raise; 
                                end   if; 
                end; 
        end   loop; 

        dbms_sql.define_column(   l_theCursor,   1,   l_columnValue, 
                                                        2000   ); 

        l_status   :=   dbms_sql.execute(l_theCursor); 

        loop 
                exit   when   (   dbms_sql.fetch_rows(l_theCursor)   <=   0   ); 
                l_separator   :=   ' '; 
                for   i   in   1   ..   l_colCnt   loop 
                        dbms_sql.column_value(   l_theCursor,   i, 
                                                                      l_columnValue   ); 
                        utl_file.put(   l_output,   l_separator   ||     
                                                                        l_columnValue   ); 
                        l_separator   :=   p_separator; 
                end   loop; 
                utl_file.new_line(   l_output   ); 
                l_cnt   :=   l_cnt+1; 
        end   loop; 
        dbms_sql.close_cursor(l_theCursor); 

        utl_file.fclose(   l_output   ); 
        return   l_cnt; 
end   dump_csv; 
/ 


You   would   use   that   for   example   like   this: 

create   or   replace   procedure   test_dump_csv 
as 
        l_rows     number; 
begin 
        l_rows   :=   dump_csv(   'select   * 
                                                      from   all_users 
                                                      where   rownum   <   25 ', 
                                                ', ',   '/tmp ',   'test.dat '   ); 
end; 
/ 


Make   sure   to   read   about   the   INIT.ORA   parameters   (utl_file_dir)   you   need   to   setup 
!!!

------解决方案--------------------

楼上这个可是ORACLE了。
其实SQL2005比较简单了。

导出数据之后
1.选择数据源，选择要导出的表
2.选择目标，平面文件源----浏览-----文件类型（选CSV文件），确定
3.下一步导出就可以了。

------解决方案--------------------

探讨

楼上这个可是ORACLE了。 
其实SQL2005比较简单了。