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

Exception handling, set serveroutput on declare a number(5); b n... set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Redeclaring predefined exceptions - user-defined exceptions, Redeclaring Pr... Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.

How transactions guard your database, How Transactions Guard Your Database ... How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Sql queries, SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.par... SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

Update command- sql, UPDATE Command- SQL Loosely speaking, UPDATE chan... UPDATE Command- SQL Loosely speaking, UPDATE changes some of the column values of some existing rows of its target table. Thus, although some rows disappear from the target an

Using %rowtype-declarations in sql, Using %ROWTYPE The %ROWTYPE attribut... Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Predefined exceptions, Predefined Exceptions The internal exception is ... Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Sql operators, SQL Operators The PL/SQL uses all the SQL set, compariso... SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Write a pl/sql anonymous block that accepts an employee id, Based on the EM... Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

Row operators - sql operators, Row Operators The Row operators return ... Row Operators The Row operators return or reference the particular rows. ALL retains the duplicate rows in the result of a query or in an aggregate expression. The DISTINCT el