Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Define an Anonymous Procedure with Variables?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

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

SQL> set serveroutput on;

SQL> declare
2 site char(80) := 'globalguideline';
3 begin
4 dbms_output.put_line('Welcome to ' || site);
5 end;
6 /
Welcome to globalguideline

PL/SQL procedure successfully completed.

SQL> /
Welcome to globalguideline

PL/SQL procedure successfully completed.

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

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Define an Anonymous Procedure without Variables?How To Create a Stored Procedure in Oracle?