Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How To Call a Stored Function?

April 26, 2017function stored

0

10 Posted

How To Call a Stored Function?

1 Answer

0

Posted

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_SITE2 RETURN VARCHAR2 AS3 BEGIN4 RETURN ‘FYICentere.com’;5 END;6 /Function created.SQL> SELECT get_site() FROM dual;GET_SITE()———————————FYICentere.comDUAL is not a real table or view. It is commonly used to with SELECT statement to evaluate expressions.