Collections:
Call a Stored Function in Oracle
How To Call a Stored Function in Oracle?
✍: FYIcenter.com
A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using SQL*Plus:
SQL> CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 BEGIN 4 RETURN 'FYICentere.com'; 5 END; 6 / Function created. SQL> SELECT get_site() FROM dual; GET_SITE() --------------------------------- FYICentere.com
DUAL is not a real table or view. It is commonly used to with SELECT statement to evaluate expressions.
⇒ Drop a Stored Function in Oracle
⇐ Create a Stored Function in Oracle
2018-10-26, 1611🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...