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, 5017👍, 0💬
Popular Posts:
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...
Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example?...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
Can JavaScript steal text from your clipboard? It is true, text you last copied for pasting (copy &a...