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
BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op


At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Dynamic SQL: The Most PL/SQL programs do a predictable, specific job. For illustration, a stored procedure may accept an employee number and salary increase, and then update t

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you