Select with specific column - Oracle

Question

I’ve been migrating to Oracle and found a question.

In SQL Server I could do so:

select coluna, * from tabela

How do I get a similar result using Oracle 12c?

Answer 1

Oracle SQL does not directly allow the use of * with another column, you need to use a alias for the table in this case, as below:

select tbl.coluna, tbl.* from tabela tbl