Re: Using Union with different data types
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 26 Nov 2002 17:27:29 -0800
Message-ID: <1b061893.0211261727.55ac0a73_at_posting.google.com>
Date: 26 Nov 2002 17:27:29 -0800
Message-ID: <1b061893.0211261727.55ac0a73_at_posting.google.com>
1- create table temp_clob( id number, name clob ); 2- create table temp_varchar ( id number, name varchar2(2000)); 3- select id, cast(name as varchar2(2000)) from temp_clob
union
select id, name from temp_varchar;
worked on my oracle 9.2.0.1.
HTH Daniel Received on Wed Nov 27 2002 - 02:27:29 CET