当前位置:数据库 > SQLServer >>

How to use SQLPlus export data to csv format

How to use SQLPlus export data to csv format
 
Sqlplus opr1d/password@swoprdb1d.nam.nsroot.net:1521/OPRISKD1
set colsep '|'
set echo off

set feedback off
set linesize 1000
set pagesize 0

set trimspool on
set headsep off

spool output.dat

select <table>.*
  from <table>
where <conditions>

spool off

 

 
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,