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.
⇒ Define Anonymous Procedures with Variables in Oracle
⇐ What Is a Function in Oracle
2018-01-27, 1504🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...