当前位置:数据库 > 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

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,