Re: Select multiple rows from DUAL ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 12 Jan 2005 23:32:54 -0800
Message-ID: <41e6243f$1_1@127.0.0.1>

Anurag Varma wrote:

> "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

You are correct. All is well with 10g.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Jan 13 2005 - 01:32:54 CST