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 - Creating Your Own PL/SQL Procedures and Functions
✍: 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, 5034👍, 0💬
Popular Posts:
Does there exist any other function which can be used to convert an integer or a float to a string? ...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? If a ta...
What is cross page posting? By default, button controls in ASP.NET pages post back to the same page ...
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...