Assignment statement in pl sql, PL-SQL Programming

Assignment Help:

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.


Related Discussions:- Assignment statement in pl sql

Parameter and keyword description - exit statement, Parameter and Keyword D...

Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Pl/sql assignment, 1. a. Write a trigger that fires when a part's price...

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

%rowtype - cursors, %ROWTYPE: This attribute gives a record type which ...

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

Merge and truncate in sql, MERGE and TRUNCATE in SQL SQL has two more ...

MERGE and TRUNCATE in SQL SQL has two more table update operators, MERGE and TRUNCATE. MERGE, like INSERT, takes a source table s and uses it to update a target table t. Brief

Example of using aggregation on nested tables, Example of Using Aggregation...

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Magento change address format depending on store, Magento change address fo...

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

Sql query on hospital database, Perform the following queries on the Hospit...

Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

Defining autonomous transactions, Defining Autonomous Transactions To ...

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Relational shema.., Find the account numbers of all customers whose balance...

Find the account numbers of all customers whose balance is more than 10,000 $

Exception handling, Exception handling In the PL/SQL, a warning or erro...

Exception handling In the PL/SQL, a warning or error condition is known as an exception. The Exceptions can be internally defined (by the run-time system) or user defined. The

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd