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, 1614🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...