Re: Query : Understand and Re-write
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