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
Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

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.

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..