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
Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

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

"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

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

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

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

which operation is used if we are interested in only certain columns of a table?

Semidifference and NOT - SQL In this section first describe the relational difference operator, named MINUS. Example here shows SQL's closest counterpart of that operator.

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a