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, 2046🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...