PL/SQL Puzzle 1: What can be removed?

View All Scripts Login to Run Script

Script Name PL/SQL Puzzle 1: What can be removed?
Description Published as a Twitter quiz on Nov 6, 2019: https://twitter.com/sfonplsql/status/1192164495654825984. Explored in my blog post: https://stevenfeuersteinonplsql.blogspot.com/2019/11/plsql-puzzle-what-code-can-be-removed.html
Area PL/SQL General
Contributor Steven Feuerstein
Created Thursday November 07, 2019

Statement 1

DECLARE
   indx        PLS_INTEGER;

   TYPE objects_t IS TABLE OF all_objects.object_name%TYPE
      INDEX BY PLS_INTEGER;

   l_empty     objects_t;
   l_objects   objects_t := l_empty;
BEGIN
   l_objects.delete;
   
   IF l_objects.LAST IS NOT NULL
   THEN
      DBMS_OUTPUT.put_line (l_objects.COUNT);
   END IF;

   l_objects (100) := 'BLIP';

     SELECT object_name
       BULK COLLECT INTO l_objects
       FROM all_objects
      WHERE object_name LIKE '%TABLE%'
   ORDER BY object_name;

   FOR indx IN 1 .. l_objects.COUNT
   LOOP
      DBMS_OUTPUT.put_line (l_objects (indx));
      EXIT WHEN indx = l_objects.COUNT;
   END LOOP;
END;

Statement processed.
ALL_ALL_TABLES
ALL_ALL_TABLES
ALL_APPLY_TABLE_COLUMNS
ALL_ATTRIBUTE_DIM_TABLES
ALL_BASE_TABLE_MVIEWS
ALL_CAPTURE_PREPARED_TABLES
ALL_CLUSTERING_TABLES
ALL_EVALUATION_CONTEXT_TABLES
ALL_EXTERNAL_TABLES
ALL_FILE_GROUP_TABLES
ALL_FILE_GROUP_TABLESPACES
ALL_GG_AUTO_CDR_TABLES
ALL_HIVE_TABLES
ALL_NESTED_TABLES
ALL_NESTED_TABLE_COLS
ALL_OBJECT_TABLES
ALL_OBJECT_TABLES
ALL_PART_TABLES
ALL_PENDING_CONV_TABLES
ALL_QUEUE_TABLES
ALL_STREAMS_TABLE_RULES
ALL_SUMMARY_DETAIL_TABLES
ALL_SYNC_CAPTURE_TABLES
ALL_TABLES
ALL_TABLES
ALL_TSTZ_TABLES
ALL_UPDATABLE_COLUMNS
ALL_UPDATABLE_COLUMNS
ALL_XML_NESTED_TABLES
ALL_XML_OUT_OF_LINE_TABLES
ALL_XML_TABLES
ALL_XTERNAL_PART_TABLES
ALL_XT_HIVE_TABLES_VALIDATION
APEX_APPL_LOAD_TABLES
APEX_APPL_LOAD_TABLE_LOOKUPS
APEX_APPL_LOAD_TABLE_RULES
APEX_UI_DEFAULTS_TABLES
AUDITABLE_OBJECT_ACTIONS
AUDITABLE_SYSTEM_ACTIONS
AWRBL_DETAILS_TYPE_TABLE
AWRBL_METRIC_TYPE_TABLE
AWRDRPT_TEXT_TYPE_TABLE
AWRRPT_HTML_TYPE_TABLE
AWRRPT_TEXT_TYPE_TABLE
AWRSQRPT_TEXT_TYPE_TABLE
AWR_CDB_TABLESPACE
AWR_CDB_TABLESPACE_STAT
AWR_CDB_TABLE_SETTINGS
AWR_OBJECT_INFO_TABLE_TYPE
AWR_PDB_TABLESPACE
AWR_PDB_TABLESPACE_STAT
AWR_PDB_TABLE_SETTINGS
AWR_ROOT_TABLESPACE
AWR_ROOT_TABLESPACE_STAT
AWR_ROOT_TABLE_SETTINGS
CDB_ADVISOR_SQLA_TABLES
CDB_ADVISOR_SQLW_TABLES
CDB_ALL_TABLES
CDB_APPLY_TABLE_COLUMNS
CDB_ATTRIBUTE_DIM_TABLES
CDB_BASE_TABLE_MVIEWS
CDB_CAPTURE_PREPARED_TABLES
CDB_CLUSTERING_TABLES
CDB_EVALUATION_CONTEXT_TABLES
CDB_EXTERNAL_TABLES
CDB_FILE_GROUP_TABLES
CDB_FILE_GROUP_TABLESPACES
CDB_FLASHBACK_ARCHIVE_TABLES
CDB_GG_AUTO_CDR_TABLES
CDB_HEATMAP_TOP_TABLESPACES
CDB_HIST_TABLESPACE
CDB_HIST_TABLESPACE_STAT
CDB_HIST_TABLE_SETTINGS
CDB_HIVE_TABLES
CDB_LOGMNR_PROFILE_TABLE_STATS
CDB_LOGSTDBY_EDS_TABLES
CDB_LOGSTDBY_UNSUPPORTED_TABLE
CDB_MINING_MODEL_TABLES
CDB_NESTED_TABLES
CDB_NESTED_TABLE_COLS
CDB_OBJECT_TABLES
CDB_PART_TABLES
CDB_PENDING_CONV_TABLES
CDB_PRIVATE_TEMP_TABLES
CDB_QUEUE_TABLES
CDB_STREAMS_RENAME_TABLE
CDB_STREAMS_TABLE_RULES
CDB_SUMMARY_DETAIL_TABLES
CDB_SYNC_CAPTURE_TABLES
CDB_TABLES
CDB_TABLESPACES
CDB_TABLESPACE_GROUPS
CDB_TABLESPACE_THRESHOLDS
CDB_TABLESPACE_USAGE_METRICS
CDB_TSTZ_TABLES
CDB_UPDATABLE_COLUMNS
CDB_XML_NESTED_TABLES
CDB_XML_OUT_OF_LINE_TABLES
CDB_XML_TABLES
CDB_XTERNAL_PART_TABLES
CDB_XT_HIVE_TABLES_VALIDATION
CQ_NOTIFICATION$_TABLE
CQ_NOTIFICATION$_TABLE_ARRAY
CUBE_TABLE
DATAPUMP_TABLE_DATA
DBA_ADVISOR_SQLA_TABLES
DBA_ADVISOR_SQLW_TABLES
DBA_ALL_TABLES
DBA_APPLY_TABLE_COLUMNS
DBA_ATTRIBUTE_DIM_TABLES
DBA_BASE_TABLE_MVIEWS
DBA_CAPTURE_PREPARED_TABLES
DBA_CLUSTERING_TABLES
DBA_EVALUATION_CONTEXT_TABLES
DBA_EXTERNAL_TABLES
DBA_FILE_GROUP_TABLES
DBA_FILE_GROUP_TABLESPACES
DBA_FLASHBACK_ARCHIVE_TABLES
DBA_GG_AUTO_CDR_TABLES
DBA_HEATMAP_TOP_TABLESPACES
DBA_HIST_TABLESPACE
DBA_HIST_TABLESPACE_STAT
DBA_HIST_TABLE_SETTINGS
DBA_HIVE_TABLES
DBA_LOGMNR_PROFILE_TABLE_STATS
DBA_LOGSTDBY_EDS_TABLES
DBA_LOGSTDBY_UNSUPPORTED_TABLE
DBA_MINING_MODEL_TABLES
DBA_NESTED_TABLES
DBA_NESTED_TABLE_COLS
DBA_OBJECT_TABLES
DBA_PART_TABLES
DBA_PENDING_CONV_TABLES
DBA_PRIVATE_TEMP_TABLES
DBA_QUEUE_TABLES
DBA_STREAMS_RENAME_TABLE
DBA_STREAMS_TABLE_RULES
DBA_SUMMARY_DETAIL_TABLES
DBA_SYNC_CAPTURE_TABLES
DBA_TABLES
DBA_TABLESPACES
DBA_TABLESPACE_GROUPS
DBA_TABLESPACE_THRESHOLDS
DBA_TABLESPACE_USAGE_METRICS
DBA_TSTZ_TABLES
DBA_UPDATABLE_COLUMNS
DBA_XML_NESTED_TABLES
DBA_XML_OUT_OF_LINE_TABLES
DBA_XML_TABLES
DBA_XTERNAL_PART_TABLES
DBA_XT_HIVE_TABLES_VALIDATION
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_STREAMS_TABLESPACE_ADM
DBMS_XPLAN_TYPE_TABLE
GV$DB_TRANSPORTABLE_PLATFORM
GV$ENCRYPTED_TABLESPACES
GV$FIXED_TABLE
GV$GOLDENGATE_TABLE_STATS
GV$TABLESPACE
GV$TRANSPORTABLE_PLATFORM
GV$XSTREAM_TABLE_STATS
KU$_FHTABLE_VIEW
KU$_HTABLE_VIEW
KU$_IOTABLE_VIEW
LOCAL_TABLE_FAMILY_SERVICES
LOGSTDBY_UNSUPPORTED_TABLES
ODCIEXTTABLEINFO
ODCIEXTTABLEQCINFO
ODCISECOBJTABLE
OLAPRC_TABLE
OLAP_TABLE
ORA_IS_CREATING_NESTED_TABLE
ORA_MINING_TABLES_NT
ORA_MINING_TABLES_NT
ORA_MINING_TABLES_NT
ORA_MINING_TABLE_TYPE
ORA_MINING_TABLE_TYPE
ORA_MINING_TABLE_TYPE
PLAN_TABLE
PLAN_TABLE$
PLAN_TABLE_OBJECT
RE$TABLE_ALIAS
RE$TABLE_ALIAS_LIST
RE$TABLE_VALUE
RE$TABLE_VALUE_LIST
SDORIDTABLE
SDORIDTABLE
SDO_DIAG_MESSAGES_TABLE
SDO_DIST_METADATA_TABLE
SDO_DIST_METADATA_TABLE
SDO_GEOR_CELL_TABLE
SDO_GEOR_CELL_TABLE
SDO_GEOR_DDL__TABLE$$
SDO_GEOR_XMLSCHEMA_TABLE
SDO_GEO_SEARCH_TABLE
SDO_INDEX_HISTOGRAM_TABLE
SDO_INDEX_HISTOGRAM_TABLE
SDO_INDEX_HISTOGRAM_TABLE_IDX
SDO_PC_BLK_TABLE
SDO_RELATEMASK_TABLE
SDO_RELATEMASK_TABLE
SDO_TIN_BLK_TABLE
SDO_TIN_PC_SYSDATA_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SEM_TERMS_TABLE
SQL_PLAN_TABLE_TYPE
SQL_PLAN_TABLE_TYPE
SRSNAMESPACE_TABLE
TABLESPACE_EXPORT_OBJECTS
TABLESPACE_EXPORT_PATHS
TABLE_EXPORT_OBJECTS
TABLE_EXPORT_PATHS
TABLE_PRIVILEGES
TABLE_PRIVILEGE_MAP
TRANSPORTABLE_EXPORT_OBJECTS
TRANSPORTABLE_EXPORT_PATHS
USER_ADVISOR_SQLA_TABLES
USER_ADVISOR_SQLA_TABLES
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLW_TABLES
USER_ALL_TABLES
USER_ALL_TABLES
USER_ATTRIBUTE_DIM_TABLES
USER_ATTRIBUTE_DIM_TABLES
USER_BASE_TABLE_MVIEWS
USER_BASE_TABLE_MVIEWS
USER_CLUSTERING_TABLES
USER_CLUSTERING_TABLES
USER_EVALUATION_CONTEXT_TABLES
USER_EVALUATION_CONTEXT_TABLES
USER_EXTERNAL_TABLES
USER_EXTERNAL_TABLES
USER_FILE_GROUP_TABLES
USER_FILE_GROUP_TABLES
USER_FILE_GROUP_TABLESPACES
USER_FILE_GROUP_TABLESPACES
USER_FLASHBACK_ARCHIVE_TABLES
USER_FLASHBACK_ARCHIVE_TABLES
USER_HIVE_TABLES
USER_HIVE_TABLES
USER_NESTED_TABLES
USER_NESTED_TABLES
USER_NESTED_TABLE_COLS
USER_NESTED_TABLE_COLS
USER_OBJECT_TABLES
USER_OBJECT_TABLES
USER_PART_TABLES
USER_PART_TABLES
USER_PENDING_CONV_TABLES
USER_PENDING_CONV_TABLES
USER_PRIVATE_TEMP_TABLES
USER_PRIVATE_TEMP_TABLES
USER_QUEUE_TABLES
USER_QUEUE_TABLES
USER_SUMMARY_DETAIL_TABLES
USER_SUMMARY_DETAIL_TABLES
USER_TABLES
USER_TABLES
USER_TABLESPACES
USER_TABLESPACES
USER_TSTZ_TABLES
USER_TSTZ_TABLES
USER_UPDATABLE_COLUMNS
USER_UPDATABLE_COLUMNS
USER_XML_NESTED_TABLES
USER_XML_NESTED_TABLES
USER_XML_OUT_OF_LINE_TABLES
USER_XML_OUT_OF_LINE_TABLES
USER_XML_PARTITIONED_TABLE_OK
USER_XML_PARTITIONED_TABLE_OK
USER_XML_TABLES
USER_XML_TABLES
USER_XTERNAL_PART_TABLES
USER_XTERNAL_PART_TABLES
USER_XT_HIVE_TABLES_VALIDATION
USER_XT_HIVE_TABLES_VALIDATION
V$DB_TRANSPORTABLE_PLATFORM
V$ENCRYPTED_TABLESPACES
V$FIXED_TABLE
V$GOLDENGATE_TABLE_STATS
V$TABLESPACE
V$TRANSPORTABLE_PLATFORM
V$XSTREAM_TABLE_STATS
XS$VALIDATION_TABLE
com/sun/org/apache/bcel/internal/generic/TABLESWITCH
org/omg/CORBA/VM_TRUNCATABLE

Statement 2

DECLARE 
   TYPE objects_t IS TABLE OF all_objects.object_name%TYPE; 
 
   l_objects   objects_t; 
BEGIN 
     SELECT object_name 
       BULK COLLECT INTO l_objects 
       FROM all_objects 
      WHERE object_name LIKE '%TABL%' 
   ORDER BY object_name; 
 
   FOR indx IN 1 .. l_objects.COUNT 
   LOOP 
      DBMS_OUTPUT.put_line (l_objects (indx)); 
   END LOOP; 
END;

Statement processed.
ALL_ALL_TABLES
ALL_ALL_TABLES
ALL_APPLY_TABLE_COLUMNS
ALL_ATTRIBUTE_DIM_TABLES
ALL_BASE_TABLE_MVIEWS
ALL_CAPTURE_PREPARED_TABLES
ALL_CLUSTERING_TABLES
ALL_EVALUATION_CONTEXT_TABLES
ALL_EXTERNAL_TABLES
ALL_FILE_GROUP_TABLES
ALL_FILE_GROUP_TABLESPACES
ALL_GG_AUTO_CDR_TABLES
ALL_HIVE_TABLES
ALL_NESTED_TABLES
ALL_NESTED_TABLE_COLS
ALL_OBJECT_TABLES
ALL_OBJECT_TABLES
ALL_PART_TABLES
ALL_PENDING_CONV_TABLES
ALL_QUEUE_TABLES
ALL_STREAMS_TABLE_RULES
ALL_SUMMARY_DETAIL_TABLES
ALL_SYNC_CAPTURE_TABLES
ALL_TABLES
ALL_TABLES
ALL_TSTZ_TABLES
ALL_UPDATABLE_COLUMNS
ALL_UPDATABLE_COLUMNS
ALL_XML_NESTED_TABLES
ALL_XML_OUT_OF_LINE_TABLES
ALL_XML_TABLES
ALL_XTERNAL_PART_TABLES
ALL_XT_HIVE_TABLES_VALIDATION
APEX_APPL_LOAD_TABLES
APEX_APPL_LOAD_TABLE_LOOKUPS
APEX_APPL_LOAD_TABLE_RULES
APEX_UI_DEFAULTS_TABLES
AUDITABLE_OBJECT_ACTIONS
AUDITABLE_SYSTEM_ACTIONS
AWRBL_DETAILS_TYPE_TABLE
AWRBL_METRIC_TYPE_TABLE
AWRDRPT_TEXT_TYPE_TABLE
AWRRPT_HTML_TYPE_TABLE
AWRRPT_TEXT_TYPE_TABLE
AWRSQRPT_TEXT_TYPE_TABLE
AWR_CDB_TABLESPACE
AWR_CDB_TABLESPACE_STAT
AWR_CDB_TABLE_SETTINGS
AWR_OBJECT_INFO_TABLE_TYPE
AWR_PDB_TABLESPACE
AWR_PDB_TABLESPACE_STAT
AWR_PDB_TABLE_SETTINGS
AWR_ROOT_TABLESPACE
AWR_ROOT_TABLESPACE_STAT
AWR_ROOT_TABLE_SETTINGS
CDB_ADVISOR_SQLA_TABLES
CDB_ADVISOR_SQLW_TABLES
CDB_ALL_TABLES
CDB_APPLY_TABLE_COLUMNS
CDB_ATTRIBUTE_DIM_TABLES
CDB_BASE_TABLE_MVIEWS
CDB_CAPTURE_PREPARED_TABLES
CDB_CLUSTERING_TABLES
CDB_EVALUATION_CONTEXT_TABLES
CDB_EXTERNAL_TABLES
CDB_FILE_GROUP_TABLES
CDB_FILE_GROUP_TABLESPACES
CDB_FLASHBACK_ARCHIVE_TABLES
CDB_GG_AUTO_CDR_TABLES
CDB_HEATMAP_TOP_TABLESPACES
CDB_HIST_TABLESPACE
CDB_HIST_TABLESPACE_STAT
CDB_HIST_TABLE_SETTINGS
CDB_HIVE_TABLES
CDB_LOGMNR_PROFILE_TABLE_STATS
CDB_LOGSTDBY_EDS_TABLES
CDB_LOGSTDBY_UNSUPPORTED_TABLE
CDB_MINING_MODEL_TABLES
CDB_NESTED_TABLES
CDB_NESTED_TABLE_COLS
CDB_OBJECT_TABLES
CDB_PART_TABLES
CDB_PENDING_CONV_TABLES
CDB_PRIVATE_TEMP_TABLES
CDB_QUEUE_TABLES
CDB_STREAMS_RENAME_TABLE
CDB_STREAMS_TABLE_RULES
CDB_SUMMARY_DETAIL_TABLES
CDB_SYNC_CAPTURE_TABLES
CDB_TABLES
CDB_TABLESPACES
CDB_TABLESPACE_GROUPS
CDB_TABLESPACE_THRESHOLDS
CDB_TABLESPACE_USAGE_METRICS
CDB_TSTZ_TABLES
CDB_UPDATABLE_COLUMNS
CDB_XML_NESTED_TABLES
CDB_XML_OUT_OF_LINE_TABLES
CDB_XML_TABLES
CDB_XTERNAL_PART_TABLES
CDB_XT_HIVE_TABLES_VALIDATION
CQ_NOTIFICATION$_TABLE
CQ_NOTIFICATION$_TABLE_ARRAY
CUBE_TABLE
DATAPUMP_TABLE_DATA
DBA_ADVISOR_SQLA_TABLES
DBA_ADVISOR_SQLW_TABLES
DBA_ALL_TABLES
DBA_APPLY_TABLE_COLUMNS
DBA_ATTRIBUTE_DIM_TABLES
DBA_BASE_TABLE_MVIEWS
DBA_CAPTURE_PREPARED_TABLES
DBA_CLUSTERING_TABLES
DBA_EVALUATION_CONTEXT_TABLES
DBA_EXTERNAL_TABLES
DBA_FILE_GROUP_TABLES
DBA_FILE_GROUP_TABLESPACES
DBA_FLASHBACK_ARCHIVE_TABLES
DBA_GG_AUTO_CDR_TABLES
DBA_HEATMAP_TOP_TABLESPACES
DBA_HIST_TABLESPACE
DBA_HIST_TABLESPACE_STAT
DBA_HIST_TABLE_SETTINGS
DBA_HIVE_TABLES
DBA_LOGMNR_PROFILE_TABLE_STATS
DBA_LOGSTDBY_EDS_TABLES
DBA_LOGSTDBY_UNSUPPORTED_TABLE
DBA_MINING_MODEL_TABLES
DBA_NESTED_TABLES
DBA_NESTED_TABLE_COLS
DBA_OBJECT_TABLES
DBA_PART_TABLES
DBA_PENDING_CONV_TABLES
DBA_PRIVATE_TEMP_TABLES
DBA_QUEUE_TABLES
DBA_STREAMS_RENAME_TABLE
DBA_STREAMS_TABLE_RULES
DBA_SUMMARY_DETAIL_TABLES
DBA_SYNC_CAPTURE_TABLES
DBA_TABLES
DBA_TABLESPACES
DBA_TABLESPACE_GROUPS
DBA_TABLESPACE_THRESHOLDS
DBA_TABLESPACE_USAGE_METRICS
DBA_TSTZ_TABLES
DBA_UPDATABLE_COLUMNS
DBA_XML_NESTED_TABLES
DBA_XML_OUT_OF_LINE_TABLES
DBA_XML_TABLES
DBA_XTERNAL_PART_TABLES
DBA_XT_HIVE_TABLES_VALIDATION
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_STREAMS_TABLESPACE_ADM
DBMS_XPLAN_TYPE_TABLE
GV$DB_TRANSPORTABLE_PLATFORM
GV$ENCRYPTED_TABLESPACES
GV$FIXED_TABLE
GV$GOLDENGATE_TABLE_STATS
GV$TABLESPACE
GV$TRANSPORTABLE_PLATFORM
GV$XSTREAM_TABLE_STATS
KU$_FHTABLE_VIEW
KU$_HTABLE_VIEW
KU$_IOTABLE_VIEW
LOCAL_TABLE_FAMILY_SERVICES
LOGSTDBY_UNSUPPORTED_TABLES
ODCIEXTTABLEINFO
ODCIEXTTABLEQCINFO
ODCISECOBJTABLE
OLAPRC_TABLE
OLAP_TABLE
ORA_IS_CREATING_NESTED_TABLE
ORA_MINING_TABLES_NT
ORA_MINING_TABLES_NT
ORA_MINING_TABLES_NT
ORA_MINING_TABLE_TYPE
ORA_MINING_TABLE_TYPE
ORA_MINING_TABLE_TYPE
PLAN_TABLE
PLAN_TABLE$
PLAN_TABLE_OBJECT
RE$TABLE_ALIAS
RE$TABLE_ALIAS_LIST
RE$TABLE_VALUE
RE$TABLE_VALUE_LIST
SDORIDTABLE
SDORIDTABLE
SDO_DIAG_MESSAGES_TABLE
SDO_DIST_METADATA_TABLE
SDO_DIST_METADATA_TABLE
SDO_GEOR_CELL_TABLE
SDO_GEOR_CELL_TABLE
SDO_GEOR_DDL__TABLE$$
SDO_GEOR_XMLSCHEMA_TABLE
SDO_GEO_SEARCH_TABLE
SDO_INDEX_HISTOGRAM_TABLE
SDO_INDEX_HISTOGRAM_TABLE
SDO_INDEX_HISTOGRAM_TABLE_IDX
SDO_PC_BLK_TABLE
SDO_RELATEMASK_TABLE
SDO_RELATEMASK_TABLE
SDO_TIN_BLK_TABLE
SDO_TIN_PC_SYSDATA_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SDO_TOPO_GEOMETRY_LAYER_TABLE
SEM_TERMS_TABLE
SQL_PLAN_TABLE_TYPE
SQL_PLAN_TABLE_TYPE
SRSNAMESPACE_TABLE
TABLESPACE_EXPORT_OBJECTS
TABLESPACE_EXPORT_PATHS
TABLE_EXPORT_OBJECTS
TABLE_EXPORT_PATHS
TABLE_PRIVILEGES
TABLE_PRIVILEGE_MAP
TRANSPORTABLE_EXPORT_OBJECTS
TRANSPORTABLE_EXPORT_PATHS
USER_ADVISOR_SQLA_TABLES
USER_ADVISOR_SQLA_TABLES
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLW_TABLES
USER_ALL_TABLES
USER_ALL_TABLES
USER_ATTRIBUTE_DIM_TABLES
USER_ATTRIBUTE_DIM_TABLES
USER_BASE_TABLE_MVIEWS
USER_BASE_TABLE_MVIEWS
USER_CLUSTERING_TABLES
USER_CLUSTERING_TABLES
USER_EVALUATION_CONTEXT_TABLES
USER_EVALUATION_CONTEXT_TABLES
USER_EXTERNAL_TABLES
USER_EXTERNAL_TABLES
USER_FILE_GROUP_TABLES
USER_FILE_GROUP_TABLES
USER_FILE_GROUP_TABLESPACES
USER_FILE_GROUP_TABLESPACES
USER_FLASHBACK_ARCHIVE_TABLES
USER_FLASHBACK_ARCHIVE_TABLES
USER_HIVE_TABLES
USER_HIVE_TABLES
USER_NESTED_TABLES
USER_NESTED_TABLES
USER_NESTED_TABLE_COLS
USER_NESTED_TABLE_COLS
USER_OBJECT_TABLES
USER_OBJECT_TABLES
USER_PART_TABLES
USER_PART_TABLES
USER_PENDING_CONV_TABLES
USER_PENDING_CONV_TABLES
USER_PRIVATE_TEMP_TABLES
USER_PRIVATE_TEMP_TABLES
USER_QUEUE_TABLES
USER_QUEUE_TABLES
USER_SUMMARY_DETAIL_TABLES
USER_SUMMARY_DETAIL_TABLES
USER_TABLES
USER_TABLES
USER_TABLESPACES
USER_TABLESPACES
USER_TSTZ_TABLES
USER_TSTZ_TABLES
USER_UPDATABLE_COLUMNS
USER_UPDATABLE_COLUMNS
USER_XML_NESTED_TABLES
USER_XML_NESTED_TABLES
USER_XML_OUT_OF_LINE_TABLES
USER_XML_OUT_OF_LINE_TABLES
USER_XML_PARTITIONED_TABLE_OK
USER_XML_PARTITIONED_TABLE_OK
USER_XML_TABLES
USER_XML_TABLES
USER_XTERNAL_PART_TABLES
USER_XTERNAL_PART_TABLES
USER_XT_HIVE_TABLES_VALIDATION
USER_XT_HIVE_TABLES_VALIDATION
V$DB_TRANSPORTABLE_PLATFORM
V$ENCRYPTED_TABLESPACES
V$FIXED_TABLE
V$GOLDENGATE_TABLE_STATS
V$TABLESPACE
V$TRANSPORTABLE_PLATFORM
V$XSTREAM_TABLE_STATS
XS$VALIDATION_TABLE
com/sun/org/apache/bcel/internal/generic/TABLESWITCH
org/omg/CORBA/VM_TRUNCATABLE

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database