Re: How to concatenate long column?

From: Dave <david.swanson_at_sprintranet.com>
Date: Tue, 15 Dec 1998 01:55:05 GMT
Message-ID: <3679c0fe.196488000@nntp.sprintisp.com>

There is no way to do this in SQL*Plus or a tool like that. If you write a Pro*C program I imagine you could... The other thing you could do is upgrade to Oracle 8 and store this kind of data in a CLOB field. You would be able to do it then with the help of the dbms_lob package...

On Mon, 14 Dec 1998 16:27:42 GMT, mingye_at_my-dejanews.com wrote:

>Hi,
>
>There is a long column in my table and I need to concatenate this column with
>some other columns. But the database always complaint ORA-00932: inconsistent
>datatypes. I understand that you can apply any database functions against long
>column, but is there any workaround?
>
>Any input will be much appreciated,
>Mingye
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 14 1998 - 19:55:05 CST