Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL and IN

Re: SQL and IN

From: Sal <sal_phipps_at_hotmail.com>
Date: 30 Jun 2003 16:10:04 -0700
Message-ID: <51925a3a.0306301510.32715549@posting.google.com>


"Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote in message news:<bdp535$uv7b5$1_at_ID-143718.news.dfncis.de>...
> Billy Verreynne wrote:
> > Christoph Seidel wrote:
> >
> >>> To do this type of thing, I usually create a second table...
> >>> You do an outer join between the date table and the widget table
> >>
> >> Well, but i do not have a second table to join with, that's the
> >> point.
> >
> > IMO, that's the only way you can do it using regular SQL.
>
> Ok, thank you.

Standard SQL will allow you to hard code tables too, e.g.   

  with my_values(id) as (values 1, 2, 4)   select a.id, b.* from my_values as a left join table as b on a.id = b.id;

However I don't know whether Oracle supports this.

Sal Received on Mon Jun 30 2003 - 18:10:04 CDT

Original text of this message

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