Collections:
Call a Sub Procedure in Oracle
How To Call a Sub Procedure in Oracle?
✍: FYIcenter.com
To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE WELCOME_PRINT(S CHAR) AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || S); 5 END; 6 BEGIN 7 WELCOME_PRINT('FYICenter'); 8 END; 9 / SQL> EXECUTE WELCOME; Welcome to FYICenter
2018-10-26, 691👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...