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
Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Table Comparison - SQL The following definitions for relation comparisons: Let r1 and r2 be relations having the same heading. Then: r1 ⊆ r2 is true if every tuple of r1

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application