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
Rephrase Conditional Control Statements When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops evaluating the expression as s

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

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

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

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

Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

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

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th