From: K Gopalakrishnan <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
