Oracle PL/SQL/PL SQL/DBMS OUTPUT

Concatenate string and number

   <source lang="sql">

SQL> SQL> set serveroutput on SQL> declare

 2    myNumber number := 1;
 3  begin
 4    myNumber := 1 + 1;
 5    dbms_output.put_line( "1 + 1 = " || to_char( myNumber ) || "!" );
 6  exception
 7    when others then
 8      dbms_output.put_line( "We encountered an exception!" );
 9  end;
10  /

1 + 1 = 2! PL/SQL procedure successfully completed. SQL> SQL>

</source>
   
  

DBMS_OUTPUT package

   <source lang="sql">

SQL> SQL> -- DBMS_OUTPUT package SQL> SQL> SQL> SQL> SET SERVEROUTPUT ON SQL> BEGIN

 2     DBMS_OUTPUT.PUT_LINE("Hello");
 3     DBMS_OUTPUT.PUT_LINE("there");
 4  END;
 5  /

Hello there PL/SQL procedure successfully completed. SQL> SQL>

      </source>
   
  

Print out value using DBMS_OUTPUT.PUT_LINE

   <source lang="sql">

SQL> SQL> --Basic loop SQL> SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE

 2    x NUMBER := 1;
 3  BEGIN
 4    LOOP
 5      DBMS_OUTPUT.PUT_LINE("This loop has executed"||TO_CHAR(x)||" time(s)");
 6      x := x +1;
 7      EXIT WHEN x > 5;
 8    END LOOP;
 9  END;
10
11
12  /

This loop has executed1 time(s) This loop has executed2 time(s) This loop has executed3 time(s) This loop has executed4 time(s) This loop has executed5 time(s) PL/SQL procedure successfully completed.

      </source>
   
  

Use dbms_output.put_line to display varchar2 type value

   <source lang="sql">

SQL> SQL> set serverout on SQL> SQL> declare

 2      myText varchar2(100);
 3    begin
 4      myText := "Hello, World!";
 5      dbms_output.put_line(myText);
 6    exception
 7      when others then
 8        dbms_output.put_line("We encountered an exception!");
 9        raise;
10    end;
11    /

Hello, World! PL/SQL procedure successfully completed. SQL>

</source>