Re: Using Union with different data types
From: justme <paulq_at_rogers.com>
Date: Wed, 27 Nov 2002 00:06:04 GMT
Message-ID: <M%TE9.170553$oRV.46251_at_news04.bloor.is.net.cable.rogers.com>
Date: Wed, 27 Nov 2002 00:06:04 GMT
Message-ID: <M%TE9.170553$oRV.46251_at_news04.bloor.is.net.cable.rogers.com>
cast the clob to char...
select id,to_char( name) from temp_clob
union
select id, name from temp_varchar.
"Srinivas" <skandu_at_yahoo.com> wrote in message
news:c6a7eae9.0211261109.100d548f_at_posting.google.com...
> I have two tables , one of which has a clob columna and the other
varchar2.
>
> 1. temp_clob( id number, name clob )
> 2. 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 Wed Nov 27 2002 - 01:06:04 CET