set serverou..." /> How To Run The Anonymous Block Again? set serverou..." /> set serverou..." />
Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Run the Anonymous Block Again?

If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script:

SQL> set serveroutput on;

SQL> begin

2 dbms_output.put_line('This is a PL/SQL FAQ.');

3 end;

4 /

This is a PL/SQL FAQ.

PL/SQL procedure successfully completed.

SQL> /

This is a PL/SQL FAQ.

PL/SQL procedure successfully completed.

What Is Stored Program Unit?

A stored program unit is a named block of codes which:

► Has a name.

► Can take parameters, and can return values.

► Is stored in the data dictionary.

► Can be called by many users.

 179 views

More Questions for you: