Re: Query : Understand and Re-write

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 24 Mar 2010 11:39:31 -0700 (PDT)
Message-ID: <714f07c5-8fad-4a01-ae45-c1ceb84cb093_at_y17g2000yqd.googlegroups.com>

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?

> which looks something like the infomation_schema views you can find in
> SQL Server

Who wudda thunk? Nice catch ...

So maybe some kind of emulation layer to run a query on Oracle to simulate some info that you might get from some cousin app running on SQL Server?

So it all goes back to Raja: what are you trying to do and why?

What's the best way to make something do less work on your system? ( Don't do it ). Received on Wed Mar 24 2010 - 13:39:31 CDT