SQL em Oracle > DML > Junção de tabelas > Junção Horizontal > Produto cartesiano
Produto cartesiano tl_logo2.jpg

O produto cartesiano entre dois conjuntos é um terceiro conjunto constituído por todos os elementos do primeiro combinados com todos os elementos do segundo.

Os comandos abaixo geram o produto cartesiado entre as tabelas EMP e DEP:

Sintaxe antiga SQL99
SELECT emp.empno,
  emp.ename,
  emp.deptno,
  dept.deptno,
  dept.dname
FROM emp,  dept;
SELECT emp.empno,
  emp.ename,
  emp.deptno,
  dept.deptno,
  dept.dname
FROM emp CROSS JOIN dept;
EMPNO                  ENAME      DEPTNO                 DEPTNO                 DNAME          
---------------------- ---------- ---------------------- ---------------------- -------------- 
7369                   SMITH      20                     10                     ACCOUNTING     
7499                   ALLEN      30                     10                     ACCOUNTING     
7521                   WARD       30                     10                     ACCOUNTING     
7566                   JONES      20                     10                     ACCOUNTING     
7654                   MARTIN     30                     10                     ACCOUNTING     
7698                   BLAKE      30                     10                     ACCOUNTING     
7782                   CLARK      10                     10                     ACCOUNTING     
7788                   SCOTT      20                     10                     ACCOUNTING     
7839                   KING       10                     10                     ACCOUNTING     
7844                   TURNER     30                     10                     ACCOUNTING     
7876                   ADAMS      20                     10                     ACCOUNTING     
7900                   JAMES      30                     10                     ACCOUNTING     
7902                   FORD       20                     10                     ACCOUNTING     
7934                   MILLER     10                     10                     ACCOUNTING     
7369                   SMITH      20                     20                     RESEARCH       
7499                   ALLEN      30                     20                     RESEARCH       
7521                   WARD       30                     20                     RESEARCH       
7566                   JONES      20                     20                     RESEARCH       
7654                   MARTIN     30                     20                     RESEARCH       
7698                   BLAKE      30                     20                     RESEARCH       
7782                   CLARK      10                     20                     RESEARCH       
7788                   SCOTT      20                     20                     RESEARCH       
7839                   KING       10                     20                     RESEARCH       
7844                   TURNER     30                     20                     RESEARCH       
7876                   ADAMS      20                     20                     RESEARCH       
7900                   JAMES      30                     20                     RESEARCH       
7902                   FORD       20                     20                     RESEARCH       
7934                   MILLER     10                     20                     RESEARCH       
7369                   SMITH      20                     30                     SALES          
7499                   ALLEN      30                     30                     SALES          
7521                   WARD       30                     30                     SALES          
7566                   JONES      20                     30                     SALES          
7654                   MARTIN     30                     30                     SALES          
7698                   BLAKE      30                     30                     SALES          
7782                   CLARK      10                     30                     SALES          
7788                   SCOTT      20                     30                     SALES          
7839                   KING       10                     30                     SALES          
7844                   TURNER     30                     30                     SALES          
7876                   ADAMS      20                     30                     SALES          
7900                   JAMES      30                     30                     SALES          
7902                   FORD       20                     30                     SALES          
7934                   MILLER     10                     30                     SALES          
7369                   SMITH      20                     40                     OPERATIONS     
7499                   ALLEN      30                     40                     OPERATIONS     
7521                   WARD       30                     40                     OPERATIONS     
7566                   JONES      20                     40                     OPERATIONS     
7654                   MARTIN     30                     40                     OPERATIONS     
7698                   BLAKE      30                     40                     OPERATIONS     
7782                   CLARK      10                     40                     OPERATIONS     
7788                   SCOTT      20                     40                     OPERATIONS     
7839                   KING       10                     40                     OPERATIONS     
7844                   TURNER     30                     40                     OPERATIONS     
7876                   ADAMS      20                     40                     OPERATIONS     
7900                   JAMES      30                     40                     OPERATIONS     
7902                   FORD       20                     40                     OPERATIONS     
7934                   MILLER     10                     40                     OPERATIONS     

56 rows selected

bthome.gifTopo


Realizado por Turtle Learning ®. Última alteração em 2011-02-26