Re: I need to vent

From: Raza Siddiqui <raza.siddiqui_at_oracle.com>
Date: Tue, 1 Mar 2016 09:17:31 -0800
Message-Id: <84FD99EA-A1DE-4E5D-A81C-649A168FBDB5_at_oracle.com>

And what is the result set ? The answer to life, the universe and everything = 42.

Just wondering if this predates arrival of any Pro* languages or PL/SQL. Oracle SQL, since v9 and certainly later has been enhanced greatly for conditional logic capabilities BUT still would not warrant compiling a "War and Peace" type tome of a statement.

On Mar 1, 2016, at 8:51, Matt Adams <MAdams_at_TroverSolutions.com> wrote:

> I've seen queries generated by many different BI tools over the years. Some were bad, some not so much (none were ever great).
>
> But this...this is an order of magnitude worse than anything I've ever seen before.
>
> 500 pages for a single statement. I'm still shaking my head in surprise and dismay.
>
> Matt
>
> -----Original Message-----
> From: John Piwowar [mailto:jpiwowar_at_gmail.com]
> Sent: Tuesday, March 01, 2016 11:49 AM
> To: Matt Adams
> Cc: oracle-l_at_freelists.org
> Subject: Re: I need to vent
>
> Exposing DBAs to queries generated by a BI tool without prior warning
> is so, so cruel.
> Rest assured, you are not alone in your pain: the number one user
> requirement for the output of that query is: "please make sure I can
> export this to Excel."
> Somewhere, the developer of a whiz-bang data visualization dashboard
> weeps, adds a menu item, and takes another shot.
>
>
> Regards,
>
> John P.
>
> On Tue, Mar 1, 2016 at 7:56 AM, Matt Adams <MAdams_at_troversolutions.com> wrote:

>> 1.8 million characters!!!!!   How in bloody hell does ANYTHING write a
>> single sql statement that 1.8 million characters long.

> **** This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. ****
> m�����祊�l��?���j������

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2016 - 18:17:31 CET