%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

Create a procedure to tax calculation task, Complete the following steps to... Complete the following steps to create a procedure to calculate the tax on an order. The BB_TAX table contains the states that require taxes to be submitted for Internet sales. If

Build a purchases report that matches the general ledger, Great Plains (Mic... Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Assignment statement in pl sql, Assignment Statement: The assignment s... Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Defining autonomous transactions, Defining Autonomous Transactions To ... Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Object types - syntax, Object Types An object type is a user-defined co... Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

Level - sql pseudocolumns, LEVEL You use the LEVEL with the SELECT CON... 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

%found - implicit cursor attributes, %FOUND Until the SQL data manipul... %FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Create a procedure that update the status, Create a procedure named STATUS_... Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Row counterparts of table operators - sql, Row Counterparts of Table Operat... 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

Example of shorthand for a row constraint - sql, Example of Shorthand for a... 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);