%type - cursors, PL-SQL Programming

%TYPE:

This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable.

Datatype:

This is simply a type specifier.

Expression:

This is a randomly complex combination of the constants, variables, literals, function calls, and operators. The simplest expression consists of the single variable. If the declaration is explained, the value of the expression is assigned to the parameter. The value and the parameter should have compatible datatypes.

Posted Date: 10/8/2012 5:56:16 AM | Location : United States







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

Write discussion on %type - cursors
Your posts are moderated
Related Questions
Positional Notation The first procedure call uses the positional notation. The PL/SQL compiler relates the first actual parameter, account, with the first proper parameter, ac

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

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

What is Cursors how to use it in Real time application ?

What are the rates for help in writing PL/SQL procedures and functions?

Transaction Visibility As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. Th