Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> BTW LONG: how about Oracle itself ?
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
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
TRIGGERJAVAC$ TRIGGERJAVAM$ TRIGGERJAVAS$
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
TABLE_NAME
PLAN_TABLE PLAN_TABLE PLAN_TABLE TOAD_PLAN_TABLE
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