Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news-lei1.dfn.de!news-fra1.dfn.de!newsfeed01.univie.ac.at!newsfeed01.highway.telekom.at!newsreader01.highway.telekom.at!not-for-mail From: Newsgroups: comp.databases.oracle.misc Subject: inline view vs. subquery Date: Fri, 4 Apr 2003 19:14:07 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_009D_01C2FADE.5D655180" X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 53 Message-ID: <3e8dbd1a$0$26102$91cee783@newsreader01.highway.telekom.at> NNTP-Posting-Host: N624P005.adsl.highway.telekom.at X-Trace: 1049476378 newsreader01.highway.telekom.at 26102 62.47.21.229 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95852 X-Received-Date: Fri, 04 Apr 2003 10:15:49 MST (news.easynews.com) ------=_NextPart_000_009D_01C2FADE.5D655180 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable inline view vs. subquery hello. i'm a newbie, can someone explain me, what's the diffrences and advantages of an inline view (select in = from-clause) and subquery(select in where-clause)? thanks, thomas ------=_NextPart_000_009D_01C2FADE.5D655180 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

inline view vs. = subquery

hello.

i'm a newbie, can someone explain = me,

what's the diffrences and advantages of = an inline=20 view (select in from-clause)

and subquery(select in = where-clause)?

thanks, = thomas

------=_NextPart_000_009D_01C2FADE.5D655180--