Effects of null for multiple assignments - sql, PL-SQL Programming

Effects of NULL for Multiple Assignments - SQL

If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If a SELECT ... INTO statement results in an empty table, then the target variables are not updated and a completion condition is given to indicate that. This is not exactly an "effect of NULL", of course, but I mention it here because of the contrast with a row subquery, which delivers a single row with NULL for each field when its table expression evaluates to an empty table. This observation might influence the choice between SET and SELECT ... INTO.

Posted Date: 1/18/2013 11:42:01 PM | Location : United States







Related Discussions:- Effects of null for multiple assignments - sql, Assignment Help, Ask Question on Effects of null for multiple assignments - sql, Get Answer, Expert's Help, Effects of null for multiple assignments - sql Discussions

Write discussion on Effects of null for multiple assignments - sql
Your posts are moderated
Related Questions
Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

ORIGIN OF EARTH - BIG-BAN G HYPOTHESIS - Origin of life is linked to origin of earth. Cosmos, the Universe originated 10-20 billion years ago by Big Bang (thermonu

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

Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau