'How to avoid "ORA-00936: missing expression" when selecting required column(s) first then remaining columns without giving column names

select columname,* from tablename

error
-----
ORA-00936: missing expression
00936. 00000 -  "missing expression"
*Cause:    
*Action:
Error at Line: 10 Column: 17

sql oracle

Solution 1:^[1]

use an alias

select columname,t1.* from tablename t1

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	nayi224