Oracle-L: Re: LONG data type in 10g

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 16 Oct 2003 08:24:39 -0800
Message-ID: <F001.005D362E.20031016082439@fatcity.com>

SQL*Plus: Release 10.1.0.0.0 - Beta on Thu Oct 16 20:35:19 2003

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).

Received on Thu Oct 16 2003 - 11:24:39 CDT