Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Define an Anonymous Procedure without Variables?

Oracle Database Interview Question
Oracle Database Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext Question
What Is an Oracle Function?How To Define an Anonymous Procedure with Variables?