在Oracle中选择column_names时的列顺序

Question

I want display a table content along with column names.

I have used SQL query for columns

"SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = $mytable"

and I have used SQL query for content

"SELECT * FROM $mytable"

Both are working fine. Only thing is that, order of columns is different. Some times its just reverse. sometimes it is reverse with some shift of 2-3 columns depending on number of column in $mytable.

Answer 1

You need to include an order by when you query ALL_TAB_COLUMNS on COLUMN_ID:

"SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = $mytable ORDER BY COLUMN_ID".

This orders the columns by the order created.