Assignment statement in pl sql, PL-SQL Programming

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 an assignment operator and an expression. Whenever the statement is executed, the expressions evaluate and the resulting value is stored in the target.

 

1257_assignment statement.png

 Keyword and Parameter Description

1) collection_name:

These identify an index-by table, nested table, or varray previously declared within the present scope.

2) cursor_variable_name:

These identify a PL/SQL cursor variable formerly declared within the present scope. Only the value of the other cursor variable can be assigned to a cursor variable.

3) host_cursor_variable_name:

These identify a cursor variable declared in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable. The host cursor's datatype variable is well-suited with the return type of any PL/SQL cursor variable. The host variables have to be prefixed with a colon.

4) host_variable_name:

These identify a variable declared in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable. The host variables should be prefixed with a colon.

5) object_name:

These identify an object (instance of the object type) formerly declared within the present scope.

6) indicator_name:

These identify an indicator variable declared in a PL/SQL host atmosphere and passed to the PL/SQL. The Indicator variables should be prefixed with a colon. The indicator variable "indicates" the value or condition of its related host variable. For illustration, in the Oracle Precompiler atmosphere, the indicator variables let you detect nulls or truncated values in the output host variables.

7) parameter_name:

These identify the formal OUT or IN OUT parameter of the subprogram in which the assignment statement become visible.

 8) index:

This is a numeric expression that should results a value of the type BINARY_INTEGER or a value implicitly convertible to that datatype.

9) record_name.field_nameP:

These identify the field in a user-defined or %ROWTYPE record earlier declared within the present scope.

10) variable_name:

These identify a PL/SQL variable earlier declared within the present scope.

Posted Date: 10/6/2012 8:39:53 AM | Location : United States







Related Discussions:- Assignment statement in pl sql, Assignment Help, Ask Question on Assignment statement in pl sql, Get Answer, Expert's Help, Assignment statement in pl sql Discussions

Write discussion on Assignment statement in pl sql
Your posts are moderated
Related Questions
Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Controlling Cursor Variables You use 3 statements to control the cursor variable: OPEN-FOR, FETCH, & CLOSE. At First, you OPEN a cursor variable FOR a multi-row query. Then, y

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

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

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope