Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Call a Stored Function with Parameters
How To Call a Stored Function with Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter:
SQL> CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER)
2 RETURN NUMBER AS
3 BEGIN
4 RETURN X * 2;
5 END;
6 /
Function created.
SQL> SELECT GET_DOUBLE(36) FROM DUAL;
GET_DOUBLE(36)
--------------
72
2007-04-25, 5465👍, 0💬
Popular Posts:
1. The basics first, please define the web in simple language? How is it connected with internet? Wh...
How To Fade Image Edges to Background Colors? - PSP Tutorials - Fading Images to Background Colors w...
What are some advantages and disadvantages of Java Sockets? Advantages of Java Sockets: Sockets are ...
How do we host a WCF service in IIS? Note: - The best to know how to host a WCF in IIS is by doing a...
What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...