change column type on select

[sanjo1]

Try using SQL PLUS command to preformat the column types. And you can change the name of the columns by using alias names in the select statement.

Hope it helps.