Oracle 8.1.7 Unions with differing datatypes in the selects
From: Phil Mac <philmccormack_at_btinternet.com>
Date: 28 Jun 2003 07:38:06 -0700
Message-ID: <54e30855.0306280638.9c0e19b_at_posting.google.com>
Date: 28 Jun 2003 07:38:06 -0700
Message-ID: <54e30855.0306280638.9c0e19b_at_posting.google.com>
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 Received on Sat Jun 28 2003 - 16:38:06 CEST