Define Anonymous Procedures without Variables in Oracle

Q

How To Define an Anonymous Procedure without Variables in Oracle?

✍: FYIcenter.com

A

Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script:

SQL> set serveroutput on;

SQL> begin 
  2    dbms_output.put_line('Welcome to FYICenter!'); 
  3  end;
  4  /
Welcome to FYICenter!

PL/SQL procedure successfully completed.

"set serveroutput on;" allows dbms_output.put_line() to work.

"/" runs the anonymous block, which print the "Welcome to FYICenter!" message.

 

Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2016-10-17, 152👍, 0💬