Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Call substr in DBMS_OUTPUT PUT_LINE

SQL> SQL> DECLARE   2     v_string VARCHAR2(500 CHAR);   3  BEGIN   4     v_string := 'recognize this, often ...';   5     DBMS_OUTPUT.PUT_LINE(SUBSTR(v_string, 1, 2));   6     DBMS_OUTPUT.PUT_LINE(SUBSTR(v_string, 6, 8));   7  END;   8  / re nize thi PL/SQL procedure successfully completed. SQL>