8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Useful Procedures And Functions

fvogt said...

-- Use stragg function aggregate items
select a.docid, stragg(a.case_id)
from ckb_sid_document_cases a
Group By A.Docid
Having Stragg(A.Case_Id) Like '%,%'

fvogt said...

Sorry, stragg is an "Ask Tom" function, not built in to Oracle.

Tim... said...


In 11g you have LISTAGG, which is a built-in version of STRAGG:


Before 11g, you could use WM_CONCAT, which is a built-in form of STRAGG also. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.