Collections:
Use "IN" Parameters in Oracle
How To Use "IN" Parameter Properly in Oracle?
✍: 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
⇒ Use "OUT" Parameters in Oracle
⇐ Parameter Modes Supported by PL/SQL in Oracle
2018-10-19, 1502🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...