Software QA (13)
SQL Server (1)
How To Define an Anonymous Procedure without Variables
How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
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.
2007-04-26, 4556👍, 0💬
What is the sequence of UML diagrams in project? First let me say some fact about this question, you...
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...