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, 1513🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...