Mon premier blog

Oracle Sql Tricks And Workarounds Zahar Hilkevich
Publisher: AuthorHouse

Oracle sum for strings varchar listagg stragg wm_concat string aggregation. Msgbarbottom The problem was a bug in the way SQL Developer uploads APEX Listener settings to the server. WM_CONCAT function Another Oracle SQL tricks to get SUM for strings. Any known tricks to workaround this issue ? Not explained at all *why* (the reason by which) the SSMA tool is unable to automatically do that trick. Powered by Microsoft® Translator. Microsoft SQL Server Migration Assistant (SSMA) Team's official blog site. The way The problem is, when you call from anonymous PL/SQL block, you're able to execute by virtue of privileges granted through roles. €� Eddie Awad (@eddieawad) December 27, 2012 · This Oracle forum post describes how to reproduce the bug and the workaround to fix it. Awads.net/VDOi8r looks like a sqldev listener admin bug. Create user-defined aggregate function; use undocumented function WM_CONCAT; use some "exotic" ways based on Oracle SQL features. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul Sent: Thursday, October 29, 2009 5:00 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Help with ORA-01039 Mark is correct; I would change slightly part of his explanation. News, views, tips and tricks on Oracle and other fun stuff. @krisrice Turns out to be the same issue reported here s. Anyway, you already helped by teaching a workaround for that issue. How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure. In Oracle 11R2 LISTAGG function was introduced. As workaround Tom Kyte advices to use sys_context, search here by 'sys_context'.