Parameter modes, PL-SQL Programming

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







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
Related Questions
What is Cursors how to use it in Real time application ?

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Project Description: We organize an online system called ACPAS we have created a project called EVO that can be use by our customers to integrate their web sites with the Acpas

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo