Hi,
We have a huge table (approx ~300 million rows) with ~150 columns in
the table.
This table is partioned in 8 partitions.
We need to extract one file per partition.

We were planning to use Fast unload for the same. But as we need data
in specific format we saw few constraints.
File delimiter has been specified in the control file as caret = ^
And we want to extract using an sql like this, but it does not work:
select column1 , column2, column3, column4 || '|' || column5 || '|' ||
column6 from table
It gives a syntax error saying that || are not recognized.

How can we concat 2 columns in Fastunload? Is it possible or not?
Are there any documents where we can refer. I could find no technical
documents on fast unload on web.

---------
If fasunload does not support concatenating the above, should we go
for Pro-C or Perl? Which one will be better?
More details:
We extracted the data of the table using fast unload and avreage row
size is approx. 700 bytes.
---------

Please suggest as this is urgent for one of our tasks,
Thanking you in advance,
Pooja

On Jun 14, 10:28*am, poojam <poojama... (AT) gmail (DOT) com> wrote:
I have no experience with fasunload.

If this is a one-time extraction, I'd go right to PERL. If this is a
production requirement (i.e., this will be done as a regular job,
repeatedly), then I'd still prefer PERL over Pro-C. Go for Pro-C if
your skill in it is much greater than your skill in PERL.

Ed
(trailing comments about using appropriate tools can be assumed here.
8^)

On Jun 14, 9:28*am, poojam <poojama... (AT) gmail (DOT) com> wrote:
Apparently you haven't tried using the concat() function:

http://download.oracle.com/docs/cd/B...htm#sthref1161


David Fitzjarrell