Re: Using Union with different data types

danielroy10_at_hotmail.com (Daniel Roy) wrote in message news:<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

Hi,

As far as i know with 9i Release-2 all the Character Functions like SUBSTR, LENGTH, INSTR etc work the same way with CLOB.

So isnt this something intresting and great.?

Regards,
Sagi Received on Wed Nov 27 2002 - 19:11:03 CET