An alias for a supertable

An alias is a word that immediately follows the name of a table in the FROM clause. You can specify an alias for a typed table in a SELECT or UPDATE statement and then use the alias (in the same SELECT or UPDATE statement) as an expression by itself. If you create an alias for a supertable, the alias can represent values from the supertable or the subtables that inherit from the supertable. In , the following query returns row values for all instances of the person, employee, and sales_rep tables.

SELECT p FROM person p;