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 Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Introduction to PL/SQL
✍: FYIcenter.com
Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this:
SQL> CREATE OR REPLACE PROCEDURE DBA_TASK (day VARCHAR2) AS 2 BEGIN 3 IF day = 'MONDAY' THEN 4 DBMS_OUTPUT.PUT_LINE('Checking log files.'); 5 ELSIF day = 'FRIDAY' THEN 6 DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); 7 ELSE 8 DBMS_OUTPUT.PUT_LINE('Reading some papers.'); 9 END IF; 10 END; 11 / SQL> EXECUTE DBA_TASK('MONDAY'); Checking log files. SQL> EXECUTE DBA_TASK('SUNDAY'); Reading some papers.
As you can see, procedures with parameters can make procedures more flexible.
2007-04-26, 4973👍, 0💬
Popular Posts:
How To Get the Minimum or Maximum Value of an Array? - PHP Script Tips - PHP Built-in Functions for ...
How to reduce the final size of an executable file? Size of the final execuatable can be reduced usi...
Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example?...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.