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, 1466🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...