Collections:
Run the Anonymous Block Again in Oracle
How To Run the Anonymous Block Again in Oracle?
✍: FYIcenter.com
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.
2018-10-30, 732👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...