Re: concat LONG

From: Michael Fontan <michael.fontan_at_autocom.dk>
Date: 14 Oct 2002 04:23:54 -0700
Message-ID: <dadac80.0210140323.7eb5ca2e@posting.google.com>

I agree with you but Oracle self doesn't seem to apply this rule... sys.user_views (Oracle 9i Release 1) is an example.

Is there a way to concat a LONG field with a VARCHAR2 or CLOB ?

Michael Fontan
Oracle DBA

>
> Please refer to the documentation for the restrictions of the
> (obsolete, available for downwards compatibility only) LONG datatype,
> and decide to stop using it. This is one of the restrictions. CLOBs
> don't have them.
>
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Mon Oct 14 2002 - 06:23:54 CDT