Oracle SQL - Table Join Tuple Variables

  1. HOME
  2. Oracle SQL
  3. Table Join
  4. Tuple Variables

Introduction

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