Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Call a Stored Function
How To Call a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: 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.
2007-04-26, 4824👍, 0💬
Popular Posts:
How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...
How do I debug thread ? This window is only seen when the program is running in debug mode. In windo...
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...