RE: SQL Question

Not sure if they would agree to snapshots, but I will suggest it anyway..

Thanks.

• Kirti

-----Original Message-----
Sent: Wednesday, May 29, 2002 3:26 PM
To: Multiple recipients of list ORACLE-L

An oversimplification no doubt... But what about creating a snapshot table for reporting?
It would be much less painfull then revisiting the column names every time a report is requested.

Now, getting a spec of reporting fields can be a challenge it its own right but... The snapshots do work....

Bob

> Dennis,
>
> Thanks for the ideas, but...
>
> 1. Not going to happen. It's a production system already in
> place (Vendor designed? But, of course!!)
>
> 2. See above.
>
> This is what happens when someone decides to write their own
> reports against tables that were not designed by themselves.
> Damagement thinks it is just a simple SELECT !!!
>
> Looks like they just will have to live with unreadable SQL !
>
> Thanks.
> - Kirti
>
> -----Original Message-----
> Sent: Wednesday, May 29, 2002 2:30 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kirti - We have a denormalized table like this in one
> database. An excellent moral lesson for those who doubt the
> wisdom of normalization.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).