Re: Query : Understand and Re-write

From: joel garry <joel-garry_at_home.com>
Date: Wed, 24 Mar 2010 13:05:43 -0700 (PDT)
Message-ID: <1bd2c4cd-72b2-4910-ae87-c5c2cacd5999_at_c20g2000prb.googlegroups.com>

On Mar 24, 11:39 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> On Mar 24, 12:27 pm, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
>
> snip
>
>
>
> > Well if you stick a " create view stupid as " on top of the SQL you
> > can then see it is trying to create the following:
>
> > SQL> desc stupid
> >  Name                                      Null?    Type
> >  ----------------------------------------- --------
> > ----------------------------
> >  TABLE_CATALOG                                      VARCHAR2
> >  TABLE_SCHEMA                                       VARCHAR2(30)
> >  TABLE_NAME                                         VARCHAR2(30)
> >  TABLE_TYPE                                         VARCHAR2(18)
> >  TABLE_GUID                                         VARCHAR2
> >  DESCRIPTION                                        VARCHAR2
> >  TABLE_PROPID                                       VARCHAR2
> >  DATE_CREATED                                       DATE
> >  DATE_MODIFIED                                      DATE
>
> Ahhh ... very nice companion to the I'm with stupid t shirt approach
> maybe?

LOL! Maybe we need a stupid view contest for an oraclenerd tshirt  :-)

jg

--
_at_home.com is bogus.  See http://oraclenerd.spreadshirt.com/ if anyone
isn't familiar with it.  Always wanted a cdos t-shirt, never could
decide exactly what to put on it.  "Why Be Denormal?" almost made it
out of my brain and into the site.

Received on Wed Mar 24 2010 - 15:05:43 CDT