Parameter and keyword description - %type attribute, PL-SQL Programming

Parameter and Keyword Description:

collection_name:

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

cursor_variable_name:

This keyword a PL/SQL cursor variable formerly declared within the present scope. Only the value of the other cursor variable can be assigned to the cursor variable.

object_name:

This keyword identifies an object (instance of the object type) formerly declared within the present scope.

record_name:

This keyword identifies a user-defined or %ROWTYPE record formerly declared within the present scope.

record_name.field_name:

This keyword identifies the field in a user-defined or %ROWTYPE record formerly declared within the present scope.

table_name.column_name:

This refers to the table and column that should be accessible when the declaration is explained.

variable_name:

This keyword identifies a variable formerly declared in similar scope.

Posted Date: 10/8/2012 8:09:45 AM | Location : United States







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

Write discussion on Parameter and keyword description - %type attribute
Your posts are moderated
Related Questions
Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau