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>