Parameter and keyword description - packages, PL-SQL Programming

Parameter and Keyword Description:

package_name:

This construct identifies the package.

AUTHID Clause:

This determine whether all the packaged subprograms implement with the rights of their invoker or definer, and whether their unskilled references to the schema objects are solved in the schema of the invoker or definer.

collection_declaration:

This identifies the index-by table, nested table, or varray formerly declared within the present scope.

constant_declaration:

The constant is declared by this construct.

exception_declaration:

An exception is declared by this construct.

object_declaration:

This identifies an object formerly declared within the present scope.

record_declaration:

The user-defined record is declared by this construct.

variable_declaration:

The variable is declared by this construct.

cursor_spec:

The interface to an explicit cursor is declared by this construct.

function_spec:

The interface to a function is declared by this construct.

procedure_spec:

The interface to a procedure is declared by this construct.

call spec:

This publishes an external C function or Java method in the Oracle data dictionary. It publishes the practice by mapping its parameter types, name, and return type to their SQL counterparts.

cursor_body:

This construct defines the fundamental implementation of an explicit cursor.

function_body:

This construct defines the fundamental implementation of the function. 

procedure_body:

This construct defines the fundamental implementation of the procedure. 

Posted Date: 10/8/2012 7:28:11 AM | Location : United States







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

Write discussion on Parameter and keyword description - packages
Your posts are moderated
Related Questions
Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates