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
Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

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

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

Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Information Hiding   With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i