Couldn't find a quick Google answer to this so hopefully this helps some one.
If you want to SELECT * in an Oracle database, but at the same time SELECT multiple custom fields, do the following:
SELECT *, NAME.Column FROM DUAL NAME;
Where NAME is a table alias you invent yourself for any table (not just DUAL).
Using a table alias is also the solution for problems with subqueries and column name issues.