concatenate CLOB data in oracle

oracle clob
user1836818 picture user1836818 · Nov 20, 2012 · Viewed 26.9k times · Source

I need to concatenate various CLOB data into a single CLOB field.

I have a database with various rows, each containing a few char fields (BATCH_ID for example), and a CLOB (BATCH_BODY). I am unsure as to how to concatenate the CLOBs in order to make everything a single row.

the end goal is to group together all rows in which the BATCH_ID is the same into a single row with a single CLOB file that is made up of various BATCH_BODY's

Answer

Kieren Johnstone picture Kieren Johnstone · Nov 20, 2012

CONCAT works with CLOBs it seems:

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions026.htm

Related questions

How to query a CLOB column in Oracle

I'm trying to run a query that has a few columns that are a CLOB datatype. If i run the query like normal, all of those fields just have (CLOB) as the value. I tried using DBMS_LOB.substr(column) …

Read More
ORA-00932: inconsistent datatypes: expected - got CLOB

Considering that TEST_SCRIPT is a CLOB why when I run this simple query from SQL*PLUS on Oracle, I get the error: ORA-00932: inconsistent datatypes: expected - got CLOB I have been reading a lot of questions about the …

Read More
How to convert CLOB to VARCHAR2 inside oracle pl/sql

I have a clob variable, need to assign it to varchar2 variable. The data inside clob var is less than 4000 (i..e varchar2's maxsize) oracle10+ I tried report_len := length(report_clob); report := TO_CHAR(dbms_lob.substr(report_…

Read More