sql function

hi everyone,

        I'm using ORACLE 8.i have following problem : I have a table with 3 fields (let's say a,b,c) :"a" and "b" are VARCHAR(2000) "c" is a LONG text.
I want to concatenate those 3 fields and put them into a new table with only
one field LONG. (let's call it D)
Problem:
I've tried this with

insert into new_table (d) select a || b || c from old_table;

result:

ORA-00932: inconsistent datatypes

Is there any possibility to solve this with only one sql statement ?

any help is appreciated., thx charly Received on Wed Jul 28 1999 - 04:31:04 CDT