Columns not matching up with data set

[johnnyx25]

We just upgraded to a new server, and Oracle is doing something strange. The column names and the row data does not match up. For example, the column will say name, while the data will be the manager. Under the manager column will be the employee_id, and under the Employee Id will be the name.

It's a simple select query that I do, and the row data comes up in the correct order. But the columns do not match what the row data is. Does anybody have any idea what the problem can be. Thnx for the help.

 

[Dagon]

If you're using SQL*Plus, check that your column headings haven't got shuffled around somehow. Type in "col employee_id" to see what the heading is.

 

[johnnyx25]

We are not using SQL* Plus, so that is not the case. Thnx for the input though.

 

[Turkbear]

Hi,
If not SqlPLus , what?
Anyway, what happens if you do use SqlPlus?

Does a desc command ( from SqlPlus) show the columns in the order you expect?