"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message
news:b1tqkc$16luv5$1_at_ID-82536.news.dfncis.de...
> Once in a while I'd trip over this weird syntax:
> THE(SELECT CAST....)
>
> I am familiar with the CAST, and the TABLE syntax, but
> have no clue as of the THE and it seems between hard
> and impossible to find this word in any electronic reference.
>
> If someone were so gentle to explain that to me, I'd appreciate
> it very much.
>
>
> Rene
Actually that's an old way of accessing nested table columns as
tables. This syntax is referred to as "THE subquery" in the docs,
is replaced with TABLE() syntax and is deprecated (but still
supported.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Thu Feb 06 2003 - 09:18:12 CST
