dbms_utility.get_parameter_value : dbms_utility « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_utility

dbms_utility.get_parameter_value

   
SQL>
SQL> declare
  2    l_intval number;
  3    l_strval varchar2(2000);
  4    l_type   number;
  5    begin
  6       l_type := dbms_utility.get_parameter_value('user_dump_dest', l_intval, l_strval);
  7       dbms_output.put_line(l_strval );
  8    end;
  9  /
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.This script demonstrates DBMS_UTILITY.NAME_TOKENIZE.
2.Use dbms_utility to time
3.time to commit
4.Call dbms_utility.get_time twice to time a statement in PL SQL
5.round dbms_utility.get_time
6.Assign dbms_utility.get_time to integer variable
7.Use dbms_utility.get_time to do performace check
8.dbms_utility.format_error_stack
9.Timing Per Thousand Records Processed (in secs)
10.Timing Package function call
11.use DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
12.DBMS_UTILITY.analyze_schema
13.demonstrates the use of DBMS_UTILITY.TABLE_TO_COMMA and DBMS_UTILITY.COMMA_TO_TABLE.
14.Performace difference between simple parameter and collection parameter