Here I am formatting the output of the first column
but not doing the same for the other 15 columns as I do not want their output to be formatted

select rpad(
lpad(
to_char(POR_TOP_ID_SENDING),
(length(POR_TOP_ID_SENDING)+10)/2
)
,10) col 1, col2....col15
from my table
where rownum < 20

Is there a way of getting the first columns output to be formatted within the select statement and leave the rest of the columns untouched "and" not having to type those columns in within the select statement??

Thanks in advance.