Use of table comparisons - sql, PL-SQL Programming

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 a value expression of type ROW ( r ) MULTISET, where r is the row type of t. However, the only operator in SQL for comparing two multisets is "=", so SQL has no direct counterparts of examples, which use "⊆", and nor does this chapter.

Those examples are shown merely to demonstrate that every constraint that can be expressed as an invocation of IS_EMPTY can be formulated alternatively as an invocation of "⊆". If SQL were to have a counterpart of that operator, it would presumably have to be an "is submultiset of " operator, where m1 is a submultiset of m2 if and only if each element of m1 appears at least as many times in m2 as it does in m1. But SQL doesn't have such an operator.

Posted Date: 1/18/2013 7:45:28 AM | Location : United States







Related Discussions:- Use of table comparisons - sql, Assignment Help, Ask Question on Use of table comparisons - sql, Get Answer, Expert's Help, Use of table comparisons - sql Discussions

Write discussion on Use of table comparisons - sql
Your posts are moderated
Related Questions
Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri

Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

Equivalences & Rewrite Rules: If notice that as well as allowing us to prove trivial theorems, and tautologies enable us to establish that certain sentences are saying the sam

heap sort program in pl/sql