PL/SQL is a block always required to server output result is to be show on the screen
otherwise output will not display .
Whenever you will work on sql prompt type "set serveroutput on". command.
SQL> set serveroutput on
Set serveroutput on Example.
otherwise output will not display .
Whenever you will work on sql prompt type "set serveroutput on". command.
SQL> set serveroutput on
Set serveroutput on Example.
SQL> set serveroutput on SQL> DECLARE eno number(5) NOT NULL := 2 ename varchar2(15) := Jay Patel; edept CONSTANT varchar2(15) := Web Developer; BEGIN dbms_output.put_line('Declared Value:'); dbms_output.put_line(' Eno: ' || eno || ' EName: ' || ename); dbms_output.put_line('Constant Declared:'); dbms_output.put_line(' EDept: ' || edept); END;
0 comments:
Post a Comment
Thank you for your comments we will get back to soon