%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
Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

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

Declarations in SQL Your program stores values in the variables and constants. As the program executes, the value of the variables can change, but the values constants cannot.

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

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

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut