Select with specific column - Oracle

Asked

Viewed 261 times

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 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
  • 2

    Thanks Diego, you did good!

  • 1

    That’s right, wonderful. Thank you!

Browser other questions tagged

You are not signed in. Login or sign up in order to post.