Find information about 'utl_file_dir' from v$parameter : parameter « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. parameter
SQL>
SQL>
SQL> SELECT name, value, isses_modifiable, issys_modifiable
  2  FROM   v$parameter
  3  WHERE  name = 'utl_file_dir';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
ISSES ISSYS_MOD
----- ---------
utl_file_dir

FALSE FALSE


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