LONG combine VARCHAR2

From: peter <hhh.database_at_gmail.com>
Date: 16 Jan 2007 02:12:46 -0800
Message-ID: <1168942365.900309.184210@a75g2000cwd.googlegroups.com>

select text from my_views where view_name='MEL_VIEW'and owner='CU' union
select owner from my_views_desc where view_name='MEL_VIEW' /
select text from my_views where view_name='MEL_VIEW'and owner='CU'

*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression

Here text has long datatype and owner has varchar2, I have to combine both is there any possiblity to do this, without recreate this table with same datatype.

TO_CHAR is not working here. Received on Tue Jan 16 2007 - 04:12:46 CST