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.
⇒ What Is a Stored Procedure in Oracle
⇐ How Many Anonymous Blocks Can Be Defined in Oracle
2018-10-30, 1447🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...