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, 4824👍, 0💬
Popular Posts:
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
How To Use an Array as a Queue? - PHP Script Tips - PHP Built-in Functions for Arrays A queue is a s...
What is the version information in XML? “version” tag shows which version of XML is used.
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
What is the method to customize columns in DataGrid? Use the template column.