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: Compatible parameter

Re: Compatible parameter

From: DenHang <reply_toDenHang_at_pi.be>
Date: Thu, 18 Jul 2002 02:12:21 +0200
Message-ID: <ah512j$84t$1@reader12.wxs.nl>


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

Original text of this message

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