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
Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Problem: (a) Define the following terms: (i) data mining. (ii) OLAP. (b) Differentiate between snowflake schema and star schema. Support your answer with appropriate

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.

Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'