Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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> --