Parameter Modes 

To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, avoid using the OUT and IN OUT modes with functions. The aim of a function is to take zero or more arguments and return a single value. To have a return function, multiple values is a bad programming practice. The functions should also be free from the side effects that change the values of variables not local to the subprogram. 

Posted Date: 10/5/2012 5:30:45 AM | Location : United States

Ask an Expert

Related Discussions:- Parameter modes, Assignment Help, Ask Question on Parameter modes, Get Answer, Expert's Help, Parameter modes Discussions

Write discussion on Parameter modes
Your posts are moderated

Write your message here..

Related Questions

Group and having query, Using a join on 2 tables, select all columns and 10... Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Iterative control: loop statement, Iterative Control: LOOP  Statements T... Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

program for employees -ado.net framework , Challenge 1 You are require... Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Using extend - collection method, Using EXTEND To enlarge the size of ... Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

Effects of null in aggregate operator - sql, Effects of NULL in Aggregate O... Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

Using savepoints, Using Savepoints The scope of the savepoint is a tra... Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

Overriding default locking, Overriding Default Locking By default, the... Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

Insert command in sql, INSERT Command in SQL Loosely speaking, INSERT... INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Pl sql code to declare cursors with parameter, Write a pl/sql block that de... Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Goto statement - sequential control, GOTO Statement The GOTO statement b... GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.