LISTAGG with CLOB? String aggregation exceeding 4000 characters with XMLAGG.

Uli Bethke Oracle

We all know that the Oracle LISTAGG function does not support the CLOB datatype. In my opinion this is a severe limitation of LISTAGG (and BTW also of PIVOT and UNPIVOT etc.). So what are your options? One option is to create your own user defined aggregate function. I found such an example on the Oracle forums. However, if you ...

Exporting & Importing Oracle Data Miner (11gR2) Workflows

Uli Bethke data mining, Irish BI SIG, Oracle, Training, Uncategorized, Web Mining

As with all development environments there will be need to move your code from one schema to another or from one database to another. With Oracle Data Miner 11gR2, we have the same requirement. In our case it is not just individual procedures or packages, we have a workflow consisting of a number of nodes. With each node we may ...

Exporting & Importing Oracle Data Miner (11gR2) Workflows

Uli Bethke data mining, Irish BI SIG, Oracle, Training, Uncategorized, Web Mining

As with all development environments there will be need to move your code from one schema to another or from one database to another. With Oracle Data Miner 11gR2, we have the same requirement. In our case it is not just individual procedures or packages, we have a workflow consisting of a number of nodes. With each node we may ...

Creating ODM Schemas & Repository for ODM 11g R2

Uli Bethke Best Practice, data mining, Oracle, Training

Before you can start using the Oracle Data Miner features that are now available in SQL Developer 3, there are a few steps you need to perform. This post will walk you through these steps and I have put together a video which goes into more detail. The video is available on my YouTube channel. http://www.youtube.com/user/btierney70 I have also created ...