This script demonstrates DBMS_UTILITY.NAME_TOKENIZE. : dbms_utility « System Packages « Oracle PL / SQL






This script demonstrates DBMS_UTILITY.NAME_TOKENIZE.

   

SQL>
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PROCEDURE Tokenize(name IN VARCHAR2) AS
  2    v_A VARCHAR2(256);
  3    v_B VARCHAR2(256);
  4    v_C VARCHAR2(256);
  5    v_DBLink VARCHAR2(256);
  6    v_NextPos BINARY_INTEGER;
  7  BEGIN
  8    DBMS_UTILITY.NAME_TOKENIZE(name, v_A, v_B, v_C, v_DBLink,
  9                               v_NextPos);
 10    DBMS_OUTPUT.PUT_LINE('a: ' || v_A);
 11    DBMS_OUTPUT.PUT_LINE('b: ' || v_B);
 12    DBMS_OUTPUT.PUT_LINE('c: ' || v_C);
 13    DBMS_OUTPUT.PUT_LINE('db link: ' || v_DBLink);
 14    DBMS_OUTPUT.PUT_LINE('next pos: ' || v_NextPos);
 15  END Tokenize;
 16  /

Procedure created.

SQL>
SQL> exec Tokenize('example.lecturer');
a: EXAMPLE
b: LECTURER
c:
db link:
next pos: 16

PL/SQL procedure successfully completed.


   
    
  








Related examples in the same category

1.Use dbms_utility to time
2.time to commit
3.dbms_utility.get_parameter_value
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