Asterisk

An asterisk, '*', used in the select list refers to all columns of the table that is specified in the FROM clause. Each column of the table is included exactly once in each row of the query results.

To select all the columns of a table or correlation, use ".*' (dot asterisk) as the suffix as shown in the following example:

 SELECT mytable.* FROM mytable

When an asterisk is used in the select list, the names of the columns as defined for the table are used as the label when accessing the columns in the rows of the query result.