Using Union with different data types
From: Srinivas <skandu_at_yahoo.com>
Date: 26 Nov 2002 11:09:56 -0800
Message-ID: <c6a7eae9.0211261109.100d548f_at_posting.google.com>
Date: 26 Nov 2002 11:09:56 -0800
Message-ID: <c6a7eae9.0211261109.100d548f_at_posting.google.com>
I have two tables , one of which has a clob columna and the other varchar2.
- temp_clob( id number, name clob )
- temp_varchar ( id number, name varchar )
I would like to have a select with union something like
select id, name from temp_clob
union
select id, name from temp_varchar.
It gives error :
" expression must have same datatype as corresponding expression"
How do I solve this.
thanks Received on Tue Nov 26 2002 - 20:09:56 CET