SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data manipulation |
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 ...
Always use the table name before the star.