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 Define Default Values for Formal Parameters
How To Define Default Values for Formal Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
If you have an IN parameter, you can make it as an optional parameter for the calling statement by defining the formal parameter with the DEFAULT clause. This gives you the freedom of not providing the actual parameter when calling this procedure or function. See the following tutorial script shows you an example procedure with an optional parameter:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE GREETING(S IN CHAR DEFAULT 'FYICenter') AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || S); 5 END; 6 BEGIN 7 GREETING('MySpace.com'); 8 GREETING; 9 END; 10 / Procedure created. SQL> EXECUTE WELCOME; Welcome to MySpace.com Welcome to FYICenter
2007-04-21, 4941👍, 0💬
Popular Posts:
What is effort variance? Effort Variance = (Actual effort – Estimated Effort) / Estimated Effort.
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...
Explain simple Walk through of XmlReader ? In this section we will do a simple walkthrough of how to...
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the rec...
What print out will the folloging code produce? main() { char *p1=“name”; char *p2; p2=(char*)malloc...