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
3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

"Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b

EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

MERGE and TRUNCATE in SQL SQL has two more table update operators, MERGE and TRUNCATE. MERGE, like INSERT, takes a source table s and uses it to update a target table t. Brief

Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know

Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin