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 Use "IN" Parameter Properly
How To Use "IN" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
Here are the rules about IN parameters:
Here is good example of a procedure with an IN parameter:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) := 'FYICenter.com'; 3 PROCEDURE WELCOME_PRINT(S IN CHAR) AS 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('Welcome to ' || S); 6 -- S := 'Google.com'; -- Not allowed 7 END; 8 BEGIN 9 WELCOME_PRINT('MySpace.com'); 10 WELCOME_PRINT(SITE); 11 END; 12 / SQL> EXECUTE WELCOME; Welcome to MySpace.com Welcome to FYICenter.com
2007-04-25, 5456👍, 0💬
Popular Posts:
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
How To Select Some Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If yo...
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
What is Native Image Generator (Ngen.exe)? The Native Image Generator utility (Ngen.exe) allows you ...