Simple Hello World using PL/SQL

[shazin]

Procedural Level/Structured Query Language is a feature that comes with Oracle DBMS, which allows developers to write procedural programs which runs on the DBMS server itself. Using PL/SQL we can eliminate the time and performance issues we would face if we are to implement the logics that involve DBMS queries.

The following code snippet shows a simple PL/SQL which prints Hello, World.

DECLARE
message varchar(100);
BEGIN
message := 'Hello, World!';
dbms_output.put_line(message);
END;