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, 1549🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...