Collections:
Define Anonymous Procedures without Variables in Oracle
How To Define an Anonymous Procedure without Variables in Oracle?
✍: FYIcenter.com
Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script:
SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('Welcome to FYICenter!'); 3 end; 4 / Welcome to FYICenter! PL/SQL procedure successfully completed.
"set serveroutput on;" allows dbms_output.put_line() to work.
"/" runs the anonymous block, which print the "Welcome to FYICenter!" message.
2018-01-27, 781👍, 0💬
Popular Posts:
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...