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!
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!