How to select column name and * in Oracle?

Hello Experts,
Can anyone tell me how to select a specific column first in the select statement then all other columns in the table?
In Sybase I can do something like this:
select column_name,* from table_name;

Thanks in advance
Who is Participating?
mustaccioConnect With a Mentor Commented:
select column_name, t.* from table_name t

Open in new window

QlemoConnect With a Mentor Batchelor and DeveloperCommented:
Yes, that works. But remember that * will list the same columns again - something like "select all other columns" does not exist in SQL ;-).
RamezAuthor Commented:
Thans a lot Mustaccio
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.