Parameter & keyword description - functions, PL-SQL Programming

Parameter & Keyword Description:

function_name:

The user-defined function is identifying by that keyword.

parameter_name:

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

IN, OUT, IN OUT:

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.

NOCOPY:

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.

Datatype:

This is merely a type specifier.

: = | DEFAULT:

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

Expression:

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.

RETURN:

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

type_definition:

This user-defined datatype is specified by this keyword.

item_declaration:

A program object is declared by this keyword.

function_declaration

The function n is declared by this construct.

procedure_declaration:

The procedure is declared by this construct.

exception_handler:

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
Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai