Hi ,
System is migrating from Oracle to Postgre SQL.
Oracle is providing BULK COLLECT INTO function to collect the multiple
records from table .
Select COL1,COL2 ,COL3 BULK COLLECT INTO LINES from Distinct_Records.
LINES IS TABLE OF TABLE1 (Defined lines as IS TABLE OF type).
In PotGres:
x27; ||
L_INV_LINES(indx).INVOICE_NUM || '''';
How do i convert this into PostgreSQL.
On Thu, Nov 9, 2017 at 4:48 PM, Laurenz Albe
wrote:
> Brahmam Eswar wrote:
> > How to migrate the Oracle collection types ( IsTableOF, IsRecord) to
> postgres.
>
> Are you talking about table definitions or PL/SQL code?
>
> Yours,
> Laurenz Albe
>
--
Thanks & Regards,
Brahmeswara Rao J.
Hi ,
How to migrate the Oracle collection types ( IsTableOF, IsRecord) to
postgres.
--
Thanks & Regards,
Brahmeswara Rao J.
