Re: Oracle data type

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 04 May 2004 21:51:32 -0700
Message-ID: <1083732690.657183@yasure>

Uthuras wrote:

> Greetings,
>
> Is there any known case of oracle allowing only one column of LONG
> data type in a table? The orcale 8 and 9 does not allow us to create
> more than one LONG data type in a particular table.
>
> Why is it so ? Is there any limitation to it ?
>
> Please advice.
>
> Thanks
>
> Uthuras

Oracle has clearly stated that LONG is not to be used. It is there for backward compatibility. So rather than getting stressed over something you shouldn't be doing ... move to CLOBs.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue May 04 2004 - 23:51:32 CDT