Re: inline view

Hi Hanne

1. Is a simple select from the table
2. is a select from the same table with a where clause
3. is a select from a different table
4. is an inline view against no.2

3 and 4 are not the same;they are selects from different tables.

You have created a SQL statement with an inline view;congratulations.

you need to spell out what you want in more detail. "Hanne Iren Midttun" <hannem_at_tihlde.org> wrote in message news:Pine.LNX.4.21.0303261415540.1886-100000_at_colargol.tihlde.org...
> Hi,
> I have never before created an inline view (and right now it look like I'm
> never going to manage to create one either..) Can somebody please tell me
> what I'm doing wrong. (Oracle 8.1.7.4 on AIX 4.3)
>
> 1)
> select * from metatab;
>
> KILDE_ID NAVN
> --------------------------------------
> 1 geo_vei
> 2 geo_vann
> 3 geo_punkt
>
> 2)
> select navn from metatab where kilde_id = 1;
>
> NAVN
> ---------------------------------------
> geo_vei
>
> 3)
> select * from geo_vei;
>
> GEOMETRI
> ---------------------------------------
> rv6
> rv7
>
> 4)
> selcet * from (select navn from metatab where kilde_id =1);
>
> NAVN
> ---------------------------------------
> geo_vei
>
> In my head I tought the select 3 and 4 where the same?
>
> regards Hanne
> --
> Hanne Midttun
> http://www.tihlde.org/~hannem
>
> English is not my native tounge
>
Received on Wed Mar 26 2003 - 08:34:48 CST