output variable value (DBMS_OUTPUT.PUT_LINE)
571744Apr 10 2007 — edited Oct 16 2007Hello,
I just started using ORACLE and am learning about PL/SQL. My question is how do you output a variable? I am running the following in an SQL Worksheet, but I can't output the value:
DECLARE
v_Temp VARCHAR2(200);
BEGIN
v_Temp :='help me';
DBMS_OUTPUT.PUT_LINE(v_Temp);
DBMS_OUTPUT.PUT_LINE('Text In Single');
END;
Thanks, sck10