Parameter & keyword description - functions, PL-SQL Programming

Parameter & Keyword Description:


The user-defined function is identifying by that keyword.


This identifies the formal parameter that is a variable declared in a function specification and referenced in the function body.


These parameter modes define the behavior of the formal parameters. An IN parameter pass the values to the subprogram being called. The OUT parameter returns values to the caller of the subprogram. An IN OUT parameter pass the initial values to the subprogram being called and return the updated values to the caller.


This is a compiler hint and not directive, that allows the PL/SQL compiler to pass the OUT and IN OUT parameters by reference rather than by the value.


This is merely a type specifier.

: = | DEFAULT:

This keyword or operator allows you to initialize the IN parameters to the default values.


This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. When the declaration is explained, the value of expression is assigned to the parameter. The value and the parameter should have the compatible datatypes.


This keyword introduces the RETURN clause that specifies the datatype of the result value. 


This user-defined datatype is specified by this keyword.


A program object is declared by this keyword.


The function n is declared by this construct.


The procedure is declared by this construct.


This construct relates an exception with a series of statements that is executed when that exception is raised.

Posted Date: 10/8/2012 6:58:11 AM | Location : United States

Related Discussions:- Parameter & keyword description - functions, Assignment Help, Ask Question on Parameter & keyword description - functions, Get Answer, Expert's Help, Parameter & keyword description - functions Discussions

Write discussion on Parameter & keyword description - functions
Your posts are moderated
Related Questions
Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

Initializing and Referencing Collections Until you initialize a collection, a nested table or varray is automatically null (i.e. the collection itself is null, not its elements)

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci