Re: Select multiple rows from DUAL ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 13 Jan 2005 06:29:40 GMT
Message-ID: <ozoFd.147169$AL5.72408@twister.nyroc.rr.com>

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:41e5cf4c$1_1_at_127.0.0.1... --snip--
> SQL> explain plan for select /*+ cardinality(t 1) */ user from
> table(array_t(1));
>
> Explained.
>

--snip--
>
> Not here.

Yup a typo. Look again. You forgot to alias the table name.

Try:
explain plan for select /*+ cardinality(t 1) */ user from table(array_t(1)) T;

                                                                                                           ^^^^

or to be more explicit:

explain plan for select /*+ cardinality(MYTABLEALIAS 1) */ user from table(array_t(1)) MYTABLEALIAS;

Anurag Received on Thu Jan 13 2005 - 00:29:40 CST