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
Renaming Columns - SQL SQL has no direct counterpart of RENAME. To derive the table on the right in Figure 4.4 from the table on the left, Tutorial D has IS_CALLED RENAME ( St

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur

Creating a Table Syantax: CREATE TABLE ENROLMENT (StudentId SID, Name   VARCHAR (30) NOT NULL, CourseId CID, PRIMARY KEY (StudentId, CourseId)) ; Explan

EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE