Collections:
Execute a Stored Procedure in Oracle
How To Execute a Stored Procedure in Oracle?
✍: FYIcenter.com
If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure:
SQL> set serveroutput on; SQL> CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welcome to FYICenter!'); 4 END; 5 / Procedure created. SQL> EXECUTE Greeting; Welcome to FYICenter!
2018-11-11, 900👍, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...