Oracle recommends others to use LOB instead of LONG. However they are lazy
to change their own.
>From: K Gopalakrishnan <kaygopal_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: LONG data type in 10g
>Date: Thu, 16 Oct 2003 08:24:39 -0800
>
>SQL*Plus: Release 10.1.0.0.0 - Beta on Thu Oct 16 20:35:19 2003
>
>Copyright (c) 1982, 2003, Oracle Corporation. All rights reserved.
>
>Connected to an idle instance.
>
>SQL> startup;
>ORACLE instance started.
>
>Total System Global Area 170990484 bytes
>Fixed Size 760724 bytes
>Variable Size 121634816 bytes
>Database Buffers 25165824 bytes
>Redo Buffers 23429120 bytes
>Database mounted.
>Database opened.
>SQL> desc view$;
> Name Null? Type
> ----------------------------------------- --------
>----------------------------
> OBJ# NOT NULL NUMBER
> AUDIT$ NOT NULL VARCHAR2(38)
> COLS NOT NULL NUMBER
> INTCOLS NOT NULL NUMBER
> PROPERTY NOT NULL NUMBER
> FLAGS NOT NULL NUMBER
> TEXTLENGTH NUMBER
> TEXT LONG
>
>SQL> desc trigger$;
> Name Null? Type
> ----------------------------------------- --------
>----------------------------
> OBJ# NOT NULL NUMBER
> TYPE# NOT NULL NUMBER
> UPDATE$ NOT NULL NUMBER
> INSERT$ NOT NULL NUMBER
> DELETE$ NOT NULL NUMBER
> BASEOBJECT NOT NULL NUMBER
> REFOLDNAME VARCHAR2(30)
> REFNEWNAME VARCHAR2(30)
> DEFINITION VARCHAR2(4000)
> WHENCLAUSE VARCHAR2(4000)
> ACTION# LONG
> ACTIONSIZE NUMBER
> ENABLED NUMBER
> PROPERTY NOT NULL NUMBER
> SYS_EVTS NUMBER
> NTTRIGCOL NUMBER
> NTTRIGATT NUMBER
> REFPRTNAME VARCHAR2(30)
> ACTIONLINENO NUMBER
>
>
>--- Mladen Gogala <mladen_at_wangtrading.com> wrote:
> > Much more menacing question:
> > Are the columns DBA_VIEWS.TEXT and DBA_TRIGGERS.TRIGGER_BODY still of
> >
> > the type long?
> >
> >
>
>
>=====
>Have a nice day !!
>------------------------------------------------------------
>Best Regards,
>K Gopalakrishnan,
>Bangalore, INDIA.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Add MSN 8 Internet Software to your current Internet access and enjoy
patented spam control and more. Get two months FREE!
http://join.msn.com/?page=dept/byoa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nancy Hu
INET: nancyhu68_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 16 2003 - 11:54:25 CDT
