• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 676
  • Last Modified:

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
0
Ramez
Asked:
Ramez
2 Solutions
 
mustaccioCommented:
Try
select column_name, t.* from table_name t

Open in new window

0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes, that works. But remember that * will list the same columns again - something like "select all other columns" does not exist in SQL ;-).
0
 
RamezAuthor Commented:
Thans a lot Mustaccio
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now