SELECT * (asterisk)


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

SELECT col1, * FROM tab1 ... 


Oracle® does not support the asterisk notation after another expression in the SELECT list.

Use the table name as a prefix to the star:

SELECT col1, tab1.* FROM tab1 ... 


Always use the table name before the star.