Definition of cross join - sql, PL-SQL Programming

Definition of CROSS JOIN - SQL

Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then:

Note: Here T denotes Table and R denotes Row

  • The heading Hs of s is the concatenation of the headings of t1 and t2, in that order.
  • If r1 is a row appearing n1 times in t1 and r2 is a row appearing n2 times in t2, then the row formed by concatenation of r1 and r2 in that order appears n1*n2 times in the body of s.

It follows that the degree of the result is the sum of the degrees of the operands and its cardinality is the product of their cardinalities, as with r1 TIMES r2.

Posted Date: 1/18/2013 4:47:57 AM | Location : United States







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

Write discussion on Definition of cross join - sql
Your posts are moderated
Related Questions
Define basic operators of relational algebra with an example each

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr