Practical Practice 1
Oracle Practice
Write a code to print “Hello World” in PLSQL block.
Write a program to print "Hello World" in PLSQL block.
SOLUTION
--Static code
set serveroutput on;
DECLARE
mes varchar2(100) := 'Hello World';
BEGIN
dbms_output.put_line(mes);
END;
/
--Dynamic code
set serveroutput on;
DECLARE
mes varchar2(100) := '&mes';
BEGIN
dbms_output.put_line(mes);
END;
/
--Dynamic code set serveroutput on; DECLARE mes varchar2(100) := '&mes'; BEGIN dbms_output.put_line(mes); END; /