%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

Write an anonymous block that contains a pl/sql procedure, Write an anonymo... Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

Using a host variable, Using a Host Variable You can declare the curso... Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Mixed notation, Mixed Notation The fourth procedure call shows that yo... Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Sqls counterpart of the key words, SQLs counterpart of the key words: ... SQLs counterpart of the key words: The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever

Multiple assignment - sql, Multiple Assignment- SQL SQL supports mult... Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Using aggregation on nested tables - sql, Using Aggregation on Nested Table... Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Example of cast operator - sql, Example of Cast Operator So long as C... Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Keyword, what is the use of declare keyword what is the use of declare keyword

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);