%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
Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Main features of PL/SQL A good way to get familiar with PL/SQL is to look at a sample program. The below program processes an order for tennis rackets. At first, it declares a

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

Processing Transactions This part describes how to do the transaction processing. You learn the fundamental techniques that safeguard the consistency of your database, involvin

Projection and Existential Quantification - SQL Intuitively it might seem that projection in SQL is simply a matter of specifying the required columns in the SELECT clause, a

I want to implement heap sort algorithm in pl sql please share the source code for guidance

ORIGIN OF EARTH - BIG-BAN G HYPOTHESIS - Origin of life is linked to origin of earth. Cosmos, the Universe originated 10-20 billion years ago by Big Bang (thermonu

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the