3
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?
3
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?
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
Browser other questions tagged sql oracle oracle12c
You are not signed in. Login or sign up in order to post.
Thanks Diego, you did good!
– Daniel Godinho
That’s right, wonderful. Thank you!
– acacio.martins