Effects of null for table expression, PL-SQL Programming

Effects of NULL for Table Expression

Here's an important distinction between expressions denoting tables and expressions denoting multisets of rows: a table expression cannot evaluate to NULL, whereas a multiset expression can. Moreover, although a row expression can evaluate to NULL-for instance, CAST ( NULL AS ROW ( X INTEGER, Y INTEGER ) ) is a legal expression-NULL cannot appear as an element of the body of a table. Every element of the body of a table is indeed a row. However, if a table has a column whose declared type is a row type, then NULL might appear in place of a value for that column in some row of that table.

Posted Date: 1/18/2013 7:46:56 AM | Location : United States







Related Discussions:- Effects of null for table expression, Assignment Help, Ask Question on Effects of null for table expression, Get Answer, Expert's Help, Effects of null for table expression Discussions

Write discussion on Effects of null for table expression
Your posts are moderated
Related Questions
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

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Authorisations - Privileges As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privilege