Re: Concatenating CLOB's

Look into the DBMS_LOB package - You need to use those functions/methods to work with all LOB ( CLOB,BLOB, etc) types.

"Ralf Becker" <rbepfhm_at_netscape.net> wrote:

>Hello!
>
>I'am a beginner with sql-programming.
>I have a table with two CLOB (Vorspann, Artikel) and want to create a table
>with the two CLOB where concatenated to one (Text).
>
>So i do somthing in SQLplus
>...
>create table Message as
>select id, job_id, ressort_id, create_date, titel, Vorspann||Artikel as Text
>, Stat_1, Stat_2, Status
>from T_Message;
>
>and get
>ORA-00932: ....
>
>What is wrong? - What must i do to concatenate CLOB's?
>
>Thanks for your help.
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Aug 09 2002 - 11:26:15 CDT