Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> BTW LONG: how about Oracle itself ?

BTW LONG: how about Oracle itself ?

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 6 May 2004 08:56:00 +0200
Message-ID: <c7cnoo$28otu$1@ID-93924.news.uni-berlin.de>


BTW, how about Oracles´ own tables containing LONGs ? In 8i (8.1.7.3 - yaya, old version, but still in service widely), I find a lot of them:

SQL> select table_name from dba_tab_columns where data_type = 'LONG';

TABLE_NAME


ALL_ARGUMENTS
ALL_CLUSTER_HASH_EXPRESSIONS
ALL_CONSTRAINTS
ALL_IND_EXPRESSIONS
ALL_IND_PARTITIONS
ALL_MVIEWS
ALL_MVIEW_AGGREGATES
ALL_MVIEW_ANALYSIS
ALL_REGISTERED_SNAPSHOTS
ALL_SNAPSHOTS
ALL_SUMMARIES
ALL_SUMMARY_AGGREGATES
ALL_TAB_COLUMNS
ALL_TAB_PARTITIONS
ALL_TRIGGERS
ALL_VIEWS

ARGUMENT$
CDEF$
COL
COL$
DBA_CLUSTER_HASH_EXPRESSIONS
DBA_CONSTRAINTS
DBA_IND_EXPRESSIONS
DBA_IND_PARTITIONS
DBA_MVIEWS
DBA_MVIEW_AGGREGATES
DBA_MVIEW_ANALYSIS
DBA_OUTLINES
DBA_REGISTERED_SNAPSHOTS
DBA_SNAPSHOTS
DBA_SUMMARIES
DBA_SUMMARY_AGGREGATES
DBA_TAB_COLUMNS
DBA_TAB_PARTITIONS
DBA_TRIGGERS
DBA_VIEWS

DIM$
EXU7CLU
EXU7CLUC
EXU7CLUI
EXU7CLUU
EXU7CON
EXU7CONU
EXU7SNAP
EXU7SNAPC
EXU7SNAPI
EXU7SNAPU
EXU7TGR
EXU7TGRC
EXU7TGRI
EXU7TGRIC
EXU7TGRU
EXU7VEW
EXU7VEWC
EXU7VEWI
EXU7VEWU
EXU816TGR TABLE_NAME

EXU816TGRC
EXU816TGRI
EXU816TGRIC
EXU816TGRU
EXU81IXCP
EXU81IXCPU
EXU81SNAP
EXU81SNAPC
EXU81SNAPI
EXU81SNAPU
EXU81SPOK
EXU81SPOKI
EXU81SPOKIU
EXU81SPOKU
EXU81TBCP
EXU81TBCPU
EXU81TGR
EXU81TGRC
EXU81TGRI
EXU81TGRIC
EXU81TGRU
EXU8CLU
EXU8CLUC
EXU8CLUI
EXU8CLUU
EXU8COE
EXU8COEU
EXU8COL
EXU8COLU
EXU8CON
EXU8CONU
EXU8COO
EXU8COOU
EXU8CSN
EXU8CSNU
EXU8DIM
EXU8DIMC
EXU8DIMI
EXU8ICO
EXU8ICOU
EXU8IXP
EXU8IXPU
EXU8POK
EXU8POKI
EXU8POKIU
EXU8POKU
EXU8SNAP
EXU8SNAPC
EXU8SNAPI
EXU8SNAPU
EXU8TBP
EXU8TBPU
EXU8TGR
EXU8TGRC
EXU8TGRI
EXU8TGRIC
EXU8TGRU TABLE_NAME

EXU8VEW
EXU8VEWC
EXU8VEWI
EXU8VEWU
EXU8VINF
EXU8VINFC
EXU8VINFI
EXU8VINFU
EXU8VNC
EXU8VNCC
EXU8VNCI
EXU8VNCU
HS$_EXTERNAL_OBJECTS
HS_EXTERNAL_OBJECTS
IDL_CHAR$
INDCOMPART$
INDPART$
ORA_KGLR7_IDL_CHAR
PLAN_TABLE
REG_SNAP$
REPCAT$_CDEF
SNAP$
SNAP_REFOP$
SQLAB_DBA_CONSTRAINTS
SUM$
SUMAGG$
SUMKEY$
TABCOMPART$
TABPART$
TRIGGER$
TRIGGERJAVAC$
TRIGGERJAVAM$
TRIGGERJAVAS$

TYPED_VIEW$
USER_ARGUMENTS
USER_CLUSTER_HASH_EXPRESSIONS
USER_CONSTRAINTS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_MVIEWS
USER_MVIEW_AGGREGATES
USER_MVIEW_ANALYSIS
USER_OUTLINES
USER_REGISTERED_SNAPSHOTS
USER_SNAPSHOTS
USER_SUMMARIES
USER_SUMMARY_AGGREGATES
USER_TAB_COLUMNS
USER_TAB_PARTITIONS
USER_TRIGGERS
USER_VIEWS

VIEW$
PRODUCT_PRIVS
SMP_LONG_TEXT
SMP_LONG_TEXT_
SQLPLUS_PRODUCT_PROFILE
AUGAUF (OK, some are here from an older user schema, but most are DDs)

TABLE_NAME



AUGINF
AUGKAR
AUGKUW
AUGPOS
AUGPOT
AUGTAK
AUGTER
HILFEN
PLAN_TABLE
TERMIN
PLAN_TABLE
PLAN_TABLE
SMP_LONG_TEXT
SMP_LONG_TEXT_
PLAN_TABLE
PLAN_TABLE
PLAN_TABLE
TOAD_PLAN_TABLE

EMBARCADERO_EXPLAIN_PLAN
PLAN_TABLE
OL$
PLAN_TABLE 193 Zeilen ausgewählt.

That is quiet a lot, isn´t it ?

SQL>
SQL> desc all_arguments

 Name                            Null?    Typ
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 OBJECT_NAME                              VARCHAR2(30)
 PACKAGE_NAME                             VARCHAR2(30)
 OBJECT_ID                       NOT NULL NUMBER
 OVERLOAD                                 VARCHAR2(40)
 ARGUMENT_NAME                            VARCHAR2(30)
 POSITION                        NOT NULL NUMBER
 SEQUENCE                        NOT NULL NUMBER
 DATA_LEVEL                      NOT NULL NUMBER
 DATA_TYPE                                VARCHAR2(30)
 DEFAULT_VALUE                            LONG ******
            in the middle of the definition, not at the end as suggested by
another poster.
 DEFAULT_LENGTH                           NUMBER
 IN_OUT                                   VARCHAR2(9)
 DATA_LENGTH                              NUMBER
 DATA_PRECISION                           NUMBER
 DATA_SCALE                               NUMBER
 RADIX                                    NUMBER
 CHARACTER_SET_NAME                       VARCHAR2(44)
 TYPE_OWNER                               VARCHAR2(30)
 TYPE_NAME                                VARCHAR2(30)
 TYPE_SUBNAME                             VARCHAR2(30)
 TYPE_LINK                                VARCHAR2(128)
 PLS_TYPE                                 VARCHAR2(30)

SQL> Has it all changed or gone with 9i / 10g ?

Just curious,
Jan Received on Thu May 06 2004 - 01:56:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US