List of Contributions

Hello Max - A quick query of Google indicates that LISTAGG does not directly support CLOBs. With Oracle, there is a database initialization parameter MAX_STRING_SIZE. By default it's set to 4000 characters. If a concatenation like LISTAGG creates a string longer than that then Oracle throws an error. ...

It just about blew my mind when I learned that I can have an arbitrary sort order for the results of a SQL script. For example: select * from ps_addresses order by case country when ' ' then '1' when 'USA' then '2' when 'CAN' then '3' when 'MEX' then '4' else country end ; :exploding_head: ...

Hi Vic - Note on dbms_lob.substr – whoever created this function hated users... I feel your pain! One of my peeves about some Oracle functions, they don't follow conventions. Start with the start position, why don'tcha! ------------------------------ Ray Martin Enterprise Applications Engineer ...

Strictly speaking, a block comment in SQL doesn't include the plus sign, e.g. select something /* my block comment */ from somewhere ; The plus sign comes in when passing a "hint" to the DBMS, when you think you have a better way to optimize the query than the automatic optimizer. That's a whole ...