Collections:
Define Anonymous Procedures with Variables in Oracle
How To Define an Anonymous Procedure with Variables in Oracle?
✍: FYIcenter.com
Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as shown in the following tutorial script:
SQL> set serveroutput on; SQL> declare 2 site char(80) := 'FYICenter'; 3 begin 4 dbms_output.put_line('Welcome to ' || site); 5 end; 6 / Welcome to FYICenter PL/SQL procedure successfully completed. SQL> / Welcome to FYICenter PL/SQL procedure successfully completed.
"/" runs the anonymous block, which print the "Welcome to FYICenter" message.
⇒ Create a Stored Procedure in Oracle
⇐ Define Anonymous Procedures without Variables in Oracle
2018-01-27, 1583🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...