How To Define an Anonymous Procedure without Variables?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online Oracle Database Job Interview Questions And Answers