Querying V_$FIXED_TABLE shows internal data dictionary structures. : V_FIXED_TABLE « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. V_FIXED_TABLE

Querying V_$FIXED_TABLE shows internal data dictionary structures.

    

SQL> select name, type
  2    from sys.v_$fixed_table
  3   where type = 'TABLE'
  4     and rownum < 6
  5  /



NAME                            TYPE
------------------------------  -----
X$KQFTA                         TABLE
X$KQFVI                         TABLE
X$KQFVT                         TABLE
X$KQFDT                         TABLE
X$KQFCO                         TABLE

5 rows selected.

SQL>

   
    
    
    
  

Related examples in the same category