Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: flat file
John Duran <d3plan_at_hotmail.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:81m71b$e6c$1_at_nnrp1.deja.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I need to send a fixed length file composed of header information and
> order information to a legacy system. (320 characters)
>
> Where can I find an example on how to do this within ORACLE 8.0.5
> running on a Sun SPARC with Solaris 2.6.
>
> Basically every day a batch file needs to be created with billing
> information or basic customer information - and a series of orders each
> with a unique ORDER_ID and information concerning items purchased,
> shipping information etc.
>
> Each detail file may have up to four different types of files each in a
> 320 fixed length character set. Each file type is designated by a 2
> digit file type. re: type 10 is 'Buyer Info', type 30 is 'Shipping
> Info' type 40 is the 'Line Item Record' - one for each item ordered.
>
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
IMHO in sql*plus no heading option and spool below
select rpad('Heading1',20,' ')||rpad('Heading2',20,' ')
from dual
union
select rpad(rtrim(column1),20,' ')||rpad(rtrim(column2),20,' ')
from table1;
Received on Fri Nov 26 1999 - 13:09:35 CST