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
Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

THEORY OF SPONTANEOUS GENERATION - ABIOGENESIS OR AUTOGENESIS - According to this theory, the existing living communities have originated from non-living organic matter with

Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

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

Set Operators The Set operators combine the results of the two queries into one result. The INTERSECT returns all the distinct rows selected by both queries. The MINUS returns

Processing Transactions This part describes how to do the transaction processing. You learn the fundamental techniques that safeguard the consistency of your database, involvin

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

Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

How do I display usernames for students from a student table, assigning each student a username initials001 (initials is the actual student initials), and if the students initials