show parameter utl_file_dir : parameter « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. parameter
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>
SQL>








30.54.parameter
30.54.1.Join v$process, v$session, v$parameter and v$instance
30.54.2.Find information about 'utl_file_dir' from v$parameter
30.54.3.show parameter utl_file_dir