Combine text and number in DBMS_OUTPUT.PUT_LINE

   
SQL> --
SQL>
SQL>    DECLARE
  2           v_Calc NUMBER := 0;
  3     BEGIN
  4          WHILE v_Calc >= 10 LOOP
  5               v_Calc := v_Calc + 1;
  6               DBMS_OUTPUT.PUT_LINE('The value of v_Calc is ' || v_Calc);
  7          END LOOP;
  8     END;
  9     /

PL/SQL procedure successfully completed.

SQL>
SQL> --

Related examples in the same category

1.	Displaying Hello World! to the Screen
2.	Call dbms_output.disable
3.	Call dbms_output.put_line to display text message
4.	dbms_output.enable
5.	EXECUTE DBMS_OUTPUT.ENABLE(10000)
6.	dbms_output.put: display text without new line sign
7.	Call dbms_output.new_line to create a new line
8.	DBMS_OUTPUT.GET_LINES
9.	A small buffer
10.	dbms_output.new_line
11.	DBMS_OUTPUT.NEW_LINE: a new line sign
12.	Use DBMS_OUTPUT.PUT_LINE to output clob data
13.	Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
14.	This script demonstrates the DBMS_OUTPUT package
15.	Output Visual line break

Combine text and number in DBMS_OUTPUT.PUT_LINE : dbms_output « System Packages « Oracle PL / SQL

Related examples in the same category