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
⇒ Define a Sub Procedure in Oracle
⇐ Drop a Stored Function in Oracle
2018-10-26, 1913🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...