Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Line overflow
Karsten,
Thanks, this is what I'm looking for. I did not find it on a Oracle
site.
Regards
Karel
"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
news:MPG.1904d3e6b20a24f498973d_at_news.la.sbcglobal.net...
> kderaedt_at_hotmail.com said...
> > Hi,
> >
> > This is probably a dummy question. I have a script that dumps the
> > output of a table to a file. If I executed this script I receive the
> > message 'Line overflow'. How can I solve this? This is my sql
statement,
> > a'm using Oracle 8.1.7.3.
> >
> > select '#'|| PAP_ADDR ||'#'|| PUSH_ID ||'#'|| DECODE (STATE,0,'No
> > State',1,'Accepted',2,'In
> >
Progress',3,'Rejected',4,'Expired',5,'Cancelled',6,'Delivered',7,'Undelivera
> > ble',8,'Pendig',9,'Awaiting Confirm',10,'Timeout',11,'Aborted','NONE')
> > ||'#'|| PUSH_INITIATOR ||'#'|| CALLBACKURL ||'#'||
> > to_char(to_date('19700101000000','yyyymmddhh24miss')+(TIME_OF_POST /
> > 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'||
> > to_char(to_date('19700101000000','yyyymmddhh24miss')+(EVENT_TIME /
> > 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'|| PAP ||'#'|| PPG ||'#'|| DECODE
> > (PRIORITY,1,'High',2,'Medium',3,'Low',99,'Ultrahigh','NONE') ||'#'||
DECODE
> > (DELIVERY_METHOD,1,'Confirmed',2,'Prefer
Confirmed',3,'Unconfirmed',4,'Not
> > Specified','NONE') ||'#'|| DECODE
> > (NETWORK_REQUIRED,0,'False',1,'True','NONE') ||'#'|| DECODE
> > (BEARER_REQUIRED,0,'False',1,'True','NONE') ||'#'|| NETWORK ||'#'||
BEARER
> > ||'#'||
to_char(to_date('19700101000000','yyyymmddhh24miss')+(DELIVER_BEFORE
> > / 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'||
> > to_char(to_date('19700101000000','yyyymmddhh24miss')+(DELIVER_AFTER /
> > 86400),'hh24:mi:ss dd.mm.yyyy') ||'#' from completed_push_tbl;
> >
> > Thanks
> >
> > Karel
> >
> Put a chr(10) - newline - here and there to break the line into multiple
> lines. You'll need to tell the program that loads this file about the
> newlines. For example,
>
>