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, 1913🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...