Re: LONG combine VARCHAR2

peter wrote:
> 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.

No, unfortunately LONG has always been extremely inflexible. I sometimes wish Oracle would stop using it in the data dictionary as they have been telling us to do in our applications for years. Received on Tue Jan 16 2007 - 04:20:48 CST