Redian新闻
>
how to dump a oracle database to csv file?
avatar
how to dump a oracle database to csv file?# Database - 数据库
j*i
1
do it like this for each table?
or is there a easier way?
SET PAGESIZE 0
SET FEEDBACK OFF
SET TERMOUT OFF
SPOOL C:\RawData\main.csv
select
TO_CHAR(mperiod,'YYYYMMDD')||','||Mstore||','||MITEM||','||MQ||','||MC||'
,'||MP
from Tablename1
/
SPOOL OFF
Thank you very much!
avatar
h*e
2
hoho, save the table directly to csv, no code needed.

【在 j**i 的大作中提到】
: do it like this for each table?
: or is there a easier way?
: SET PAGESIZE 0
: SET FEEDBACK OFF
: SET TERMOUT OFF
: SPOOL C:\RawData\main.csv
: select
: TO_CHAR(mperiod,'YYYYMMDD')||','||Mstore||','||MITEM||','||MQ||','||MC||'
: ,'||MP
: from Tablename1

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。