Oracle SQL - Table Join Tuple Variables


Consider the following SQL statements:

select ename, init, job
from   emp
where  deptno = 20;

We could have written this statement as follows: Using Tuple Variables in a Query

select e.ename, e.init, e.job
from   emp e
where  e.deptno = 20;

Here, e is a tuple variable.

In Oracle, tuple variables are referred to as table aliases, and the ANSI/ISO standard calls it correlation names.

Related Topics