Re: "Long" Datatypes in Oracle 8

prab.athilat_at_fmr.com wrote:

> Matt M. Aulbaugh wrote:
> >
> > Is it true that the "Long" Datatypes will be done away with in Oracle 8
> > and that VARCHAR2 would have to be used in it's place?
> NO...In fact LONG is replaced with LOB . varchar2 remains there with
> column size upto 4000.
> Prab Athilat

Long = CLOB, Long Raw = BLOB, and a new type for storing files at the os level and not within the database is BFILE. All oracle 8 features.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, drop column script
ICQ UIN:  2832230(&oracle, home).