%TYPE Attribute

The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype specifier whenever declaring the variables, constants, fields, and parameters.

Syntax:

Posted Date: 10/8/2012 8:08:40 AM | Location : United States

Ask an Expert

Related Discussions:- %type attribute - syntax, Assignment Help, Ask Question on %type attribute - syntax, Get Answer, Expert's Help, %type attribute - syntax Discussions

Write discussion on %type attribute - syntax
Your posts are moderated

Write your message here..

Related Questions

Parameter default values, Parameter Default Values As the illustration ... 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

Biochemical origin of life - modern concept, BIOCHE M ICA L ORIGIN OF LI... BIOCHE M ICA L ORIGIN OF LIFE - It is generally agreed by astronomers, geologists and biologists that the earth is approximately 4500-5000 million years old. It is an

Obtaining a natural join by specifying the common columns, Obtaining a natu... Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe

Assignments in pl/sql, Assignments in pl/sql The Variables and constants... Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

Bulk binds advantages, Bulk Binds advantages In the Embedded Oracle RDB... Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur

Constants and variables in pl sql, Constants and Variables:   You can... Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Keyword and parameter description - goto statement, Keyword and Parameter D... Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Return statement, RETURN Statement The RETURN statement instantly compl... 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

Using rollback - , Using ROLLBACK The ROLLBACK statements end the pres... Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo

Example of foreign key constraint - sql, Example of Foreign Key Constraint ... Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam