plsql Hello World


Example

The following simple procedure displays the text "Hello World" in a client that supports dbms_output.

CREATE OR REPLACE PROCEDURE helloworld
AS
BEGIN
   dbms_output.put_line('Hello World!');
END;
/

You need to execute this at the SQL prompt to create the procedure in the database, or you can run the query below to get the same result:

SELECT 'Hello World!' from dual;