Select with specific column - Oracle

Navigation
2

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

In SQL Server I could do this: 

select coluna, * from tabela

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

    
asked by anonymous 11.06.2018 / 15:45

1 answer

0

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

select tbl.coluna, tbl.* from tabela tbl
    
11.06.2018 / 15:47
Is there a correct way to write this code? [duplicate] Link library boost with cmake?