Re: I need to vent

On 2016/03/01 09:56, Matt Adams wrote:

> 1.8 million characters!!!!! How in bloody hell does ANYTHING write a single sql statement that 1.8 million characters long.
>
> _ [snip]_
>
> I just needed to vent a little to somebody who might understand. What's the most egregious statement you've come across?

I had to check the dozens of consultant-written UPDATE statements I have that are >38K lines and ~1.9MB each. The CASE clause has multiple IN lists, each with the max 1000 entries, and each of those entries has a corresponding IN list entry in the WHERE clause. I distinctly remember trying to find the missing comma in one, when SQL*Plus said the error was on line 1 (it ended up being on line 14-thousand-something, I think).

Good thing these were only used once for a data conversion. I wish that they had just created tables to put the data conversions in that I could've updated from, but oh well...

Fun stuff, Matt!

Rich

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