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

Ask an Expert

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

Write your message here..

Related Questions

Scoping-naming conventions, Scoping Within the similar scope, all the de... 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.

Built-in functions-comparison operators, Built-In Functions The PL/SQL p... Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

Parameter and keyword description - sql cursor, Parameter and Keyword Descr... Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

Short-circuit evaluation-pl/sql expressions , Short-Circuit Evaluation ... Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Natural join - sql, Natural Join - SQL In the absence of NATURAL JOIN... Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Opening a cursor, Opening a Cursor Opening the cursor executes the que... Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin

Enforce security in the database system, Question: (a) In the context o... Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Example of using aggregation on nested tables, Example of Using Aggregation... Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Data abstraction, Data Abstraction The Data abstraction extracts the im... Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Theory of special creation - origin of life, THEO R Y OF SPECIAL CREATION... THEO R Y OF SPECIAL CREATION - Life originated on the earth due to natural events by the super natural power. The biblical story of creation of world within six days was p