We are migrating a SQL Server 2000 view to Oracle 8.1.7. There is one
view which uses a Union statement, which in the first select, the 8th
column is selecting a varchar2, and in the second select the 8th col
is a CLOB.
Has anyone written their own TO_CHAR function that will take a CLOB
and convert it, as the Oracle provided functions do not work correctly
on this version. They work OK in 9.
Cheers
view which uses a Union statement, which in the first select, the 8th
column is selecting a varchar2, and in the second select the 8th col
is a CLOB.
Has anyone written their own TO_CHAR function that will take a CLOB
and convert it, as the Oracle provided functions do not work correctly
on this version. They work OK in 9.
Cheers