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, 1519🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...