System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. Show parameter utl_file_dir
SQL>
SQL> select * from v$parameter where name = 'utl_file_dir'
  2  /
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
       817 utl_file_dir
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
         2
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
TRUE      FALSE FALSE     FALSE FALSE      FALSE FALSE
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
utl_file accessible directories list
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
 379739569
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
SQL>