The star (asterisk) in SELECT statements

Informix® allows you to use the star character in the select list along with other expressions:

SELECT col1, * FROM tab1 ... 

Oracle does not support this. You must use the table name as a prefix to the star:

SELECT col1, tab1.* FROM tab1 ... 

Solution

Always use the table name before the star.