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 Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Procedures The procedure is a subprogram which can take parameters and be invoked. Normally, you can use a procedure to perform an action. The procedure has 2 sections: the spe

Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il