Selecting specific columns along with asteric from a table

In Oracle if you select specific columns along with asteric, it generates an error.

This problem can resolved by querying the following way, as in many cases we need to see specific columns values along with the rest of the columns. You simply need to use an alias of the table to get the result.

Select ename, e.* from emp e;