Collections:
Call a Stored Functoin with Parameters in Oracle
How To Call a Stored Function with Parameters in Oracle?
✍: FYIcenter.com
You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter:
SQL> CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER) 2 RETURN NUMBER AS 3 BEGIN 4 RETURN X * 2; 5 END; 6 / Function created. SQL> SELECT GET_DOUBLE(36) FROM DUAL; GET_DOUBLE(36) -------------- 72
2018-10-26, 832👍, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, y...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...