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, 1572🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...