Interesting properties of cross join - sql, PL-SQL Programming

Interesting properties of CROSS JOIN - SQL

Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOIN, CROSS JOIN is not idempotent. Let t be any table and let n be its cardinality. Then t CROSS JOIN t has twice as many columns as t and n2 rows. Also unlike JOIN, CROSS JOIN has no identity value. If t is a table, there is no table t0 such that t CROSS JOIN t0 = t. That's because t0 would be required to have no columns and exactly one row, but SQL doesn't recognize the existence of tables with no columns.

Posted Date: 1/18/2013 4:48:50 AM | Location : United States







Related Discussions:- Interesting properties of cross join - sql, Assignment Help, Ask Question on Interesting properties of cross join - sql, Get Answer, Expert's Help, Interesting properties of cross join - sql Discussions

Write discussion on Interesting properties of cross join - sql
Your posts are moderated
Related Questions
Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

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

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.

Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of