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
Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

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

Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

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

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ