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, 3294🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......