Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>