Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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 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...

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)