sqlplus script help

From: Neil Greene <neil_at_kynug.org>
Date: 8 Feb 93 23:00:13 GMT
Message-ID: <1993Feb8.230013.23541_at_kynug.org>


I have a script that dumps several tables data to a file. (boy, that sure was not easy) Everything works fine, including the conversion so that Macintosh can read the file. Now, there is one field I have left out and it is of type LONG RAW. I need to concatenate this field with my other VARCHARS, which is not allowed through SQL*Plus.

The output currently looks like this:

> field1, field2, field3, field4, ..., fieldn

If I add the ruling field, which is a LONGRAW, that causes the line length to go over the 500 character limit, it looks like this:

> Record1_field1, field2, field3, field4, ..., fieldn
> LONG_RAW_TEXT_FIELD_STARTS_ON_NEWLINE1
> Record2_field1, field2, field3, field4, ..., fieldn
> LONG_RAW_TEXT_FIELD_STARTS_ON_NEWLINE2
Any suggestions?? SED, AWK, etc. Any suggestions directly from Oracle?? What about these line length limitations??

-- 
Neil Greene
President, Kentucky NeXT User Group, Inc.
Email: neil_at_kynug.org [NeXTMail]
Received on Tue Feb 09 1993 - 00:00:13 CET

Original text of this message