Run the Anonymous Block Again in Oracle

Q

How To Run the Anonymous Block Again in Oracle?

✍: FYIcenter.com

A

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.

 

⇒Introduction to Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-16, 163👍, 0💬

General MySQL Oracle SQL Server