[Home] [Help]
[Dependency Information]
TABLE: SYS.COL$
Object Details
Object Name: | COL$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_COL1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
NAME
|
I_COL3
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
INTCOL#
|
I_COL2
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
OBJ#
COL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
COL# |
NUMBER |
|
Yes |
|
SEGCOL# |
NUMBER |
|
Yes |
|
SEGCOLLENGTH |
NUMBER |
|
Yes |
|
OFFSET |
NUMBER |
|
Yes |
|
NAME |
VARCHAR2 |
(128) |
Yes |
|
TYPE# |
NUMBER |
|
Yes |
|
LENGTH |
NUMBER |
|
Yes |
|
FIXEDSTORAGE |
NUMBER |
|
Yes |
|
PRECISION# |
NUMBER |
|
|
|
SCALE |
NUMBER |
|
|
|
NULL$ |
NUMBER |
|
Yes |
|
DEFLENGTH |
NUMBER |
|
|
|
DEFAULT$ |
LONG |
(0) |
|
|
INTCOL# |
NUMBER |
|
Yes |
|
PROPERTY |
NUMBER |
|
Yes |
|
CHARSETID |
NUMBER |
|
|
|
CHARSETFORM |
NUMBER |
|
|
|
EVALEDITION# |
NUMBER |
|
|
|
UNUSABLEBEFORE# |
NUMBER |
|
|
|
UNUSABLEBEGINNING# |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE5 |
VARCHAR2 |
(1000) |
|
|
SPARE6 |
DATE |
|
|
|
SPARE7 |
NUMBER |
|
|
|
SPARE8 |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, COL#
, SEGCOL#
, SEGCOLLENGTH
, OFFSET
, NAME
, TYPE#
, LENGTH
, FIXEDSTORAGE
, PRECISION#
, SCALE
, NULL$
, DEFLENGTH
, DEFAULT$
, INTCOL#
, PROPERTY
, CHARSETID
, CHARSETFORM
, EVALEDITION#
, UNUSABLEBEFORE#
, UNUSABLEBEGINNING#
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, SPARE8
FROM SYS.COL$;
Dependencies
[top of page]
SYS.COL$ does not reference any database object
SYS.COL$ is referenced by following:
-
CTXSYS
-
DRICON
- show dependent code
-
DRIREPZ
- show dependent code
-
DRI_MOVE_CTXSYS
- show dependent code
-
LBACSYS
-
OLS$POLICY_COLUMNS
-
SYS
-
ALL_ASSOCIATIONS
-
ALL_COL_PENDING_STATS
-
ALL_COL_PRIVS
-
ALL_COL_PRIVS_MADE
-
ALL_COL_PRIVS_RECD
-
ALL_CONS_COLUMNS
-
ALL_CONS_OBJ_COLUMNS
-
ALL_CUBE_DIM_VIEW_COLUMNS
-
ALL_CUBE_HIER_VIEW_COLUMNS
-
ALL_CUBE_VIEW_COLUMNS
-
ALL_DIM_ATTRIBUTES
-
ALL_DIM_LEVEL_KEY
-
ALL_EDITIONING_VIEW_COLS
-
ALL_EDITIONING_VIEW_COLS_AE
-
ALL_ENCRYPTED_COLUMNS
-
ALL_IND_COLUMNS
-
ALL_IND_EXPRESSIONS
-
ALL_JOIN_IND_COLUMNS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_LOB_TEMPLATES
-
ALL_LOG_GROUP_COLUMNS
-
ALL_MVIEW_AGGREGATES
-
ALL_MVIEW_JOINS
-
ALL_MVIEW_KEYS
-
ALL_NESTED_TABLES
-
ALL_NESTED_TABLE_COLS
-
ALL_OBJECT_TABLES
-
ALL_OBJ_COLATTRS
-
ALL_PART_KEY_COLUMNS
-
ALL_PART_LOBS
-
ALL_QUEUE_TABLES
-
ALL_REFS
-
ALL_STAT_EXTENSIONS
-
ALL_SUBPART_KEY_COLUMNS
-
ALL_SUMMARY_AGGREGATES
-
ALL_SUMMARY_JOINS
-
ALL_SUMMARY_KEYS
-
ALL_TAB_COLS_V$
-
ALL_TAB_COL_STATISTICS
-
ALL_TAB_HISTGRM_PENDING_STATS
-
ALL_TAB_HISTOGRAMS
-
ALL_TAB_IDENTITY_COLS
-
ALL_TRIGGER_COLS
-
ALL_TSTZ_TAB_COLS
-
ALL_UNUSED_COL_TABS
-
ALL_UPDATABLE_COLUMNS
-
ALL_USTATS
-
ALL_VARRAYS
-
ALL_XMLTYPE_COLS
-
ALL_XML_TABLES
-
ALL_XML_TAB_COLS
-
ALL_XML_VIEWS
-
ALL_XML_VIEW_COLS
-
CDBVIEW
- show dependent code
-
COL
-
COLUMN_PRIVILEGES
-
DBA_ADVISOR_SQLA_COLVOL
-
DBA_ADVISOR_SQLW_COLVOL
-
DBA_ASSOCIATIONS
-
DBA_AUDIT_POLICY_COLUMNS
-
DBA_CLUSTERING_JOINS
-
DBA_CLUSTERING_KEYS
-
DBA_CLU_COLUMNS
-
DBA_COL_PENDING_STATS
-
DBA_COL_PRIVS
-
DBA_CONS_COLUMNS
-
DBA_CONS_OBJ_COLUMNS
-
DBA_CUBE_DIM_VIEW_COLUMNS
-
DBA_CUBE_HIER_VIEW_COLUMNS
-
DBA_CUBE_VIEW_COLUMNS
-
DBA_DIM_ATTRIBUTES
-
DBA_DIM_JOIN_KEY
-
DBA_DIM_LEVEL_KEY
-
DBA_EDITIONING_VIEW_COLS
-
DBA_EDITIONING_VIEW_COLS_AE
-
DBA_ENCRYPTED_COLUMNS
-
DBA_IND_COLUMNS
-
DBA_IND_EXPRESSIONS
-
DBA_JOIN_IND_COLUMNS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_LOB_TEMPLATES
-
DBA_LOGSTDBY_NOT_UNIQUE
-
DBA_LOG_GROUP_COLUMNS
-
DBA_MVIEW_AGGREGATES
-
DBA_MVIEW_JOINS
-
DBA_MVIEW_KEYS
-
DBA_NESTED_TABLES
-
DBA_NESTED_TABLE_COLS
-
DBA_OBJECT_TABLES
-
DBA_OBJ_COLATTRS
-
DBA_OLDIMAGE_COLUMNS
-
DBA_PART_KEY_COLUMNS
-
DBA_PART_LOBS
-
DBA_QUEUE_TABLES
-
DBA_REFS
-
DBA_SEC_RELEVANT_COLS
-
DBA_SENSITIVE_DATA
-
DBA_SQL_PLAN_DIR_OBJECTS
-
DBA_STAT_EXTENSIONS
-
DBA_STREAMS_COLUMNS
-
DBA_SUBPART_KEY_COLUMNS
-
DBA_SUMMARY_AGGREGATES
-
DBA_SUMMARY_JOINS
-
DBA_SUMMARY_KEYS
-
DBA_TAB_COLS_V$
-
DBA_TAB_COL_STATISTICS
-
DBA_TAB_HISTGRM_PENDING_STATS
-
DBA_TAB_HISTOGRAMS
-
DBA_TAB_IDENTITY_COLS
-
DBA_TRIGGER_COLS
-
DBA_TSDP_POLICY_PROTECTION
-
DBA_UNUSED_COL_TABS
-
DBA_UNUSED_PRIVS
-
DBA_UPDATABLE_COLUMNS
-
DBA_USED_PRIVS
-
DBA_USTATS
-
DBA_VARRAYS
-
DBA_XMLTYPE_COLS
-
DBA_XML_TABLES
-
DBA_XML_TAB_COLS
-
DBA_XML_VIEWS
-
DBA_XML_VIEW_COLS
-
DBA_ZONEMAP_MEASURES
-
DBMSOBJG
- show dependent code
-
DBMSOBJG_DP
- show dependent code
-
DBMS_APPLY_ADM_INTERNAL
- show dependent code
-
DBMS_AQADM_SYS
- show dependent code
-
DBMS_CDC_IMPDP
- show dependent code
-
DBMS_CDC_UTILITY
- show dependent code
-
DBMS_DEFERGEN
- show dependent code
-
DBMS_DEFERGEN_AUDIT
- show dependent code
-
DBMS_DEFERGEN_INTERNAL
- show dependent code
-
DBMS_DEFERGEN_UTIL
- show dependent code
-
DBMS_EXPORT_EXTENSION_I
- show dependent code
-
DBMS_INTERNAL_LOGSTDBY
- show dependent code
-
DBMS_LOGMNR_D
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_OBJECTS_UTILS
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_PRVTAQIM
- show dependent code
-
DBMS_PRVTAQIP
- show dependent code
-
DBMS_REDACT_INT
- show dependent code
-
DBMS_REDEFINITION_INTERNAL
- show dependent code
-
DBMS_REPCAT_CONF
- show dependent code
-
DBMS_REPCAT_DECL
- show dependent code
-
DBMS_REPCAT_FLA_UTL
- show dependent code
-
DBMS_REPCAT_MAS
- show dependent code
-
DBMS_REPCAT_MIG_INTERNAL
- show dependent code
-
DBMS_REPCAT_OBJ_UTL
- show dependent code
-
DBMS_REPCAT_UTL
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
DBMS_REPCAT_UTL3
- show dependent code
-
DBMS_REPCAT_UTL4
- show dependent code
-
DBMS_SNAPSHOT_UTL
- show dependent code
-
DBMS_SQLPATCH
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STREAMS_ADM_UTL
- show dependent code
-
DICT_COLUMNS
-
DMP_SEC
- show dependent code
-
EXPGETENCCOLNAM
-
EXU10ASC
-
EXU10CCL
-
EXU10COE
-
EXU112DLOB
-
EXU11IND
-
EXU7CCL
-
EXU7CCO
-
EXU7CGR
-
EXU7COL
-
EXU7COL_TEMP
-
EXU7ICO
-
EXU7TAB
-
EXU81ASSOC
-
EXU81LBSP
-
EXU81SPOK
-
EXU81SPOKI
-
EXU81TAB
-
EXU8ASC
-
EXU8CCL
-
EXU8CCO
-
EXU8CGR
-
EXU8CMT
-
EXU8COE
-
EXU8COL
-
EXU8COL_TEMP
-
EXU8COL_TEMP_TTS_UNUSED_COL
-
EXU8COL_TTS_UNUSED_COL
-
EXU8COO
-
EXU8CSN
-
EXU8ICO
-
EXU8INK
-
EXU8NTB
-
EXU8ORFS
-
EXU8POK
-
EXU8POKI
-
EXU8REF
-
EXU8RFS
-
EXU8TAB
-
EXU8TABC
-
EXU8TABI
-
EXU92TSPL
-
EXU9BJW
-
EXU9CCL
-
EXU9COE
-
EXU9COO
-
EXU9COO_TTS_UNUSED_COL
-
EXU9IND
-
EXU9INHCOLCONS
-
EXU9LBCP
-
EXU9LBP
-
EXU9LOB
-
EXU9PLB
-
EXU9TABS
-
EXU9TAB_UNUSED_COLS
-
GET_STATS_EXTENSION
-
IMP_LOB_INFO
-
IMP_LOB_NOTNULL
-
INT$DBA_COL_COMMENTS
-
INT$DBA_JSON_COLUMNS
-
KU$_10_1_IND_STATS_VIEW
-
KU$_10_1_PTAB_COL_STATS_VIEW
-
KU$_10_1_TABLE_OBJNUM_VIEW
-
KU$_10_1_TAB_COL_STATS_VIEW
-
KU$_10_2_IND_STATS_VIEW
-
KU$_10_2_STRMCOL_VIEW
-
KU$_10_2_TAB_COL_VIEW
-
KU$_ALL_TSLTZ_TAB_COLS
-
KU$_ASSOC_VIEW
-
KU$_CLSTCOL_VIEW
-
KU$_COLUMN_VIEW
-
KU$_COMMENT_VIEW
-
KU$_CUBE_FACT_VIEW
-
KU$_CUBE_TAB_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FGA_POLICY_VIEW
-
KU$_FIND_ATTRCOL_VIEW
-
KU$_FIND_HIDDEN_CONS_VIEW
-
KU$_FIND_NTAB_ATTRCOL_VIEW
-
KU$_FIND_SGCOL_VIEW
-
KU$_FIND_SGC_COLS_VIEW
-
KU$_FIND_SGI_COLS_VIEW
-
KU$_HISTGRM_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IDENTITY_COL_VIEW
-
KU$_IND_COL_VIEW
-
KU$_IONT_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_OBJGRANT_VIEW
-
KU$_OIDINDEX_VIEW
-
KU$_PART_COL_NAMES_VIEW
-
KU$_PCOLUMN_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_PKREF_CONSTRAINT_VIEW
-
KU$_PRIM_COLUMN_VIEW
-
KU$_QUEUE_TABLE_VIEW
-
KU$_RADM_MC_VIEW
-
KU$_RLS_POLICY_VIEW
-
KU$_SEQ_IN_DEFAULT_VIEW
-
KU$_SIMPLE_COL_VIEW
-
KU$_SIMPLE_PKREF_COL_VIEW
-
KU$_SIMPLE_SETID_COL_VIEW
-
KU$_STRMCOL_VIEW
-
KU$_TABCLUSTER_COL_VIEW
-
KU$_TAB_COL_VIEW
-
KU$_TLOB_COMPPART_VIEW
-
KU$_TRIGGERCOL_VIEW
-
KU$_UNLOAD_METHOD_VIEW
-
KU$_XSRLS_POLICY_VIEW
-
LOADER_COL_FLAGS
-
LOADER_COL_INFO
-
LOADER_COL_TYPE
-
LOADER_FULL_ATTR_NAME
-
LOADER_INTCOL_INFO
-
LOADER_LOB_FLAGS
-
LOADER_LOB_INDEX_COL
-
LOADER_NESTED_VARRAYS
-
LOADER_OID_INFO
-
LOGMNR$ALWAYSSUPLOG_PROC
- show dependent code
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_GTCS_CAT_SUPPORT
-
LOGMNR_TAB_COLS_CAT_SUPPORT
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
LOGSTDBY_SUPPORT_TAB_10_1
-
LOGSTDBY_SUPPORT_TAB_10_2
-
LOGSTDBY_SUPPORT_TAB_11_1
-
LOGSTDBY_SUPPORT_TAB_11_2
-
LOGSTDBY_SUPPORT_TAB_11_2B
-
LOGSTDBY_SUPPORT_TAB_12_1
-
LOGSTDBY_UNSUPPORT_TAB_10_1
-
LOGSTDBY_UNSUPPORT_TAB_10_2
-
LOGSTDBY_UNSUPPORT_TAB_11_1
-
LOGSTDBY_UNSUPPORT_TAB_11_2
-
LOGSTDBY_UNSUPPORT_TAB_11_2B
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
PRVT_ILM
- show dependent code
-
REDACTION_COLUMNS
-
ROLE_TAB_PRIVS
-
STRADDLING_RS_OBJECTS
-
TP$
-
TSDP$DATAPUMP
- show dependent code
-
TSP$
-
USER_ADVISOR_SQLA_COLVOL
-
USER_ADVISOR_SQLW_COLVOL
-
USER_ASSOCIATIONS
-
USER_CLU_COLUMNS
-
USER_COL_PENDING_STATS
-
USER_COL_PRIVS
-
USER_COL_PRIVS_MADE
-
USER_COL_PRIVS_RECD
-
USER_CONS_COLUMNS
-
USER_CONS_OBJ_COLUMNS
-
USER_CUBE_DIM_VIEW_COLUMNS
-
USER_CUBE_HIER_VIEW_COLUMNS
-
USER_CUBE_VIEW_COLUMNS
-
USER_DIM_ATTRIBUTES
-
USER_DIM_LEVEL_KEY
-
USER_EDITIONING_VIEW_COLS
-
USER_EDITIONING_VIEW_COLS_AE
-
USER_IND_COLUMNS
-
USER_IND_EXPRESSIONS
-
USER_JOIN_IND_COLUMNS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_LOB_TEMPLATES
-
USER_LOG_GROUP_COLUMNS
-
USER_MVIEW_AGGREGATES
-
USER_MVIEW_JOINS
-
USER_MVIEW_KEYS
-
USER_NESTED_TABLES
-
USER_NESTED_TABLE_COLS
-
USER_OBJECT_TABLES
-
USER_OBJ_COLATTRS
-
USER_OLDIMAGE_COLUMNS
-
USER_PART_KEY_COLUMNS
-
USER_PART_LOBS
-
USER_QUEUE_TABLES
-
USER_REFS
-
USER_STAT_EXTENSIONS
-
USER_SUBPART_KEY_COLUMNS
-
USER_SUMMARY_AGGREGATES
-
USER_SUMMARY_JOINS
-
USER_SUMMARY_KEYS
-
USER_TAB_COLS_V$
-
USER_TAB_COL_STATISTICS
-
USER_TAB_HISTGRM_PENDING_STATS
-
USER_TAB_HISTOGRAMS
-
USER_TAB_IDENTITY_COLS
-
USER_TRIGGER_COLS
-
USER_UNUSED_COL_TABS
-
USER_UPDATABLE_COLUMNS
-
USER_USTATS
-
USER_VARRAYS
-
USER_XML_COLUMN_NAMES
-
USER_XML_PARTITIONED_TABLE_OK
-
USER_XML_TABLES
-
USER_XML_TAB_COLS
-
USER_XML_VIEWS
-
USER_XML_VIEW_COLS
-
_DBA_APPLY_TABLE_COLUMNS_H
-
_DBA_STREAMS_UNSUPPORTED_10_1
-
_DBA_STREAMS_UNSUPPORTED_10_2
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_11_2
-
_DBA_STREAMS_UNSUPPORTED_12_1
-
_DBA_STREAMS_UNSUPPORTED_9_2
-
_DBA_XSTREAM_OUT_ADT_PK_TABLES
-
_user_stat
-
XDB
-
DBMS_XMLSTORAGE_MANAGE
- show dependent code