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
Using Cursor Attributes: Every cursor has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. If appended to the cursor name, they return the helpful information about

Project Description: I want somebody who can help me with an idea that I have been working on for a few months now. The person will require extensive knowledge of warcraft 3 PvP

Wrapping and unwrapping in SQL Operators WRAP and UNWRAP in connection with attributes whose declared types are tuple types. Example shows how extension and projection can be

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

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

THEORY OF SPONTANEOUS GENERATION - ABIOGENESIS OR AUTOGENESIS - According to this theory, the existing living communities have originated from non-living organic matter with

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t