Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Compatible parameter
Thanks. I allready encountered in-line views, I just didn't realised the
strength of them. This surely helps me a lot.
> This is not a reason for a temorary table in Oracle.
>
> In Oracle this is easily accomplished by what are called IN-LINE VIEWS (in
TSQL
> derived tables). The form very simly is as follows:
>
> SELECT field, field, field
> FROM (
> SELECT field, field, field
> FROM
> WHERE
> AND ... ) alias,
> another_in-line_view alias,
> a_table,
> another_table
> WHERE
> GROUP BY
> HAVING
> ORDER BY
>
> We don't have limited locks or a need to keep transactions small. Use
temporary
> tables on the above and you kill scalability and performance.
>
> Daniel Morgan
>
Received on Wed Jul 17 2002 - 19:12:21 CDT