Search:
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




After Work

Highlife Adventures
The best club in Chicago
for Chicago Singles is Highlife Adventures!


Jersey Girl Shirts
Are you looking for a
Jersey Girl T-Shirt ?



Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!


Oracle » PL-SQL » SQL-Plus » Extract-File-Ou

Formatting Records for Output Files in SQL-Plus

     


SQL Plus was originally a reporting utility. Unfortunately, it is the only tool provided
by Oracle for generating flat files. To remove the 'friendly' formatting, here
are the commands required:





set echo off
set newpage 0
set pagesize 0
set space 0
set feedback off
set trimspool on
set heading off
set linesize 555



-- Then, to create a flat file, with pipe delimiters:



spool invoices.dat;

select invoice_id || '|' ||
invoice_dt || '|' ||
total_amt
from invoices
order by invoice_id
;

spool off;

exit











Oracle : Related Topics

Oracle : PL-SQL : Editing SQL within SQL-Plus
Oracle : PL-SQL : Passing parms to a SQL script via SQL-Plus

Sybase Web Site
Sybase Mobile Web Site
Oracle Web Site





Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2008 Citisoft Inc All Rights Reserved.