Re: Dumping database into text format.

Quick sqlplus - remember I am a beginner

REM A SQL SCRIPT TO BE RUN FROM SQLPLUS THAT CREATES A COMMA DELIMITTED CSV  FILE
REM which will be sent to SAS
REM
REM John McGrath Oct 14, 1997

SET PAGESIZE 0
SET FEEDBACK OFF
SET TERMOUT OFF SPOOL S:\RawData\main.csv

select
 TO_CHAR(mperiod,'YYYYMMDD')||','||Mstore||','||MITEM||','||MQ||','||MC||' ,'||MP
from Blah.mainallagg

/

SPOOL OFF

################

The TO_CHAR thing is a date conversionfunction

Enjoy !

John McGrath Received on Mon Nov 03 1997 - 00:00:00 CST