Basic Oracle Concepts and Programming Question:

How To Define an Anonymous Procedure without Variables?

Tweet Share WhatsApp

Answer:

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 globalguideline!');
3 end;
4 /
Welcome to globalguideline!

PL/SQL procedure successfully completed.

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

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

Download Oracle Database PDF Read All 430 Oracle Database Questions
Previous QuestionNext Question
What Is an Oracle Function?How To Define an Anonymous Procedure with Variables?