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
⇒ Define a Sub Function in Oracle
⇐ Define a Sub Procedure in Oracle
2018-10-26, 1972🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...