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
BETWEEN Operator The operator BETWEEN, tests whether the value lies in a specified series. That means "greater than or equivalent to low value and less than or equivalent to hig

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

What are 3 good practices of modeling and/or implementing data warehouses?

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

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Projection and Existential Quantification - SQL Intuitively it might seem that projection in SQL is simply a matter of specifying the required columns in the SELECT clause, a

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t