plsql PLSQL procedure 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;
