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
Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

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

Write a cursor to open an employee database and fetch the employee record whose age is greater than 45