Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: COBOL flat file to Oracle
When I went through Oracle8 manual it says you can create a table with
datatype of VARRAY, which is variable array. But the thing is I don't find
enough examples for it. I don't know after that how will I access it or load
data in it thru' SQL LOADER. Has anyone worked with Variable arrays i,e
VARRAYS?
Thank you,
Abeeda
In article <6h2v3h$djo$1_at_nnrp1.dejanews.com>,
Abeeda_Mohammed_at_xn.xerox.com wrote:
>
> Hello,
>
> I have a COBOL layout in which each field is defined as an array which occurs
> 84 times.i.e Gross_qty occurs 84 times, net_qty occurs 84 times etc; I have
> to load this into an Oracle table. Is there a way to define arrays in Oracle
> tables ?
>
> Thank you,
>
> Abeeda
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 08:19:21 CDT