Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL Collection

Re: PLSQL Collection

From: simon <simon_at_simon.com>
Date: Tue, 14 Jun 2005 21:01:57 +0800
Message-ID: <42aed542$1_2@rain.i-cable.com>

<andrewst_at_onetel.com> ¦b¶l¥ó
news:1118750353.592510.28930_at_g47g2000cwa.googlegroups.com ¤¤¼¶¼g...
>
> The first thing you will find is that TRIM is not allowed with INDEX
> BY.
>

This is exactly what makes me confused. The 9iR2's PLSQL User's Guide and Reference never mention about this restriction. Actually, it claims trim is applicable to collection - which means INDEX BY TABLES, NESTED TABLES and Varrays!!!

So my actual question is which collection type is trim applicable to? Received on Tue Jun 14 2005 - 08:01:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US