Parameter and keyword description - procedures, PL-SQL Programming

Parameter and Keyword Description:

procedure_name

The user-defined procedure is declared by this construct.

parameter_name:

This identifies the formal parameter that is a variable declared in the procedure specification and referenced in the procedure 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 the values to the caller of the subprogram. An IN OUT parameter passes the initial values to the subprogram being called and returns the updated values to the caller.

NOCOPY:

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

Datatype:

The datatype construct is 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 easiest expression consists of a single variable. When the declaration is explained, the value of the expression is assigned to the parameter. The value and the parameter should have the compatible datatypes.

type_definition:

The user-defined datatype is specified by this construct.

item_declaration:

This declares the program object

function_declaration:

This construct declares the function.

procedure_declaration:

The procedure is declared by this keyword.

exception_handler:

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

Posted Date: 10/8/2012 7:33:00 AM | Location : United States







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

Write discussion on Parameter and keyword description - procedures
Your posts are moderated
Related Questions
Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

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

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

Variable Declaration - SQL SQL's support for variables is very similar to Tutorial D's, except that the syntax for creating persistent  variables-base tables-is quite differen