SQL trace : Session variable « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. Session variable

SQL trace

    
SQL>
SQL>
SQL> set serveroutput on
SQL>
SQL> VARIABLE v_String1 VARCHAR2(20);
SQL> VARIABLE v_String2 VARCHAR2(20);
SQL>
SQL> BEGIN
  2    :v_String1 := 'Hello';
  3    :v_String2 := ' World!';
  4  END;
  5  /

PL/SQL procedure successfully completed.

SQL>
SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 4';

Session altered.

SQL>
SQL>
SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE(:v_String1 || :v_String2);
  3  END;
  4  /
Hello World!

PL/SQL procedure successfully completed.

SQL>
SQL>

   
    
    
  

Related examples in the same category