Re: Problem with a compless query on Oracle 8i..

On Thu, 03 Jul 2003 19:24:20 +0200, HeavyBrain <actis_at_heavybrain.net> wrote:

>Hi,
>
>I must write a query on a schema designed by a programmer ( bad
>designed on my opinion, but i can redesign it) for a one shoot report
>for management.

My bad english at work... :(

I want to write "BUT I CAN'T REDESIGN IT"....

The schema was designed for easy insert of data and in some case without constraint (removed for solve application bugs)...

Every time a statistical report or data extraction is required is a pain :(

My one dime suggestion... don't allow programmers write database schemas ;-)

Best Regards

     .And.

--
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.

Voster semper Voster
 HeavyBrain aka .Andrea Actis.