|Useful Procedures And Functions - Procedures and functions you may have overlooked which can come in useful during development.|
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.
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. :)