Example for output on Screen "DBMS_ OUTPUT.PUT_LINE()"

DECLARE

variable12 VARCHAR2(30)

BEGIN

variable12 := '&input;

DBMS_OUTPUT.PUT_LINE('hey cammon'|| variable12);

END;

/*ohaaa.sql is contain this code */

------------------------------------------------------------------

SQL> ohaaa.sql

Enter value for input: yok

old 3: variable12 VARCHAR2(30) := '&input';

new 3: variable12 VARCHAR2(30) := 'yok';

hey cammon yok

PL/SQL procedure successfully completed.

Okcan Yasin

PL/SQL General Statement

[DECLARE]

declaration statements

BEGIN

execution statements

[EXCEPTION]

exception handling statements

END;

pl/sql Example

Unfortunately Many CS student cant learn pl/sql.So Many CS student and CS's substiute student learn PL/SQL on this BLOG.