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
Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

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

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa