Comments
| Useful Procedures And Functions - Procedures and functions you may have overlooked which can come in useful during development. |
fvogt said... -- Use stragg function aggregate itemsselect 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... Hi.In 11g you have LISTAGG, which is a built-in version of STRAGG: http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php Before 11g, you could use WM_CONCAT, which is a built-in form of STRAGG also. :) Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
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!