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
Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Controlling Cursor Variables You use 3 statements to control the cursor variable: OPEN-FOR, FETCH, & CLOSE. At First, you OPEN a cursor variable FOR a multi-row query. Then, y

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM