Hello,

I have the results of a query which appears as follows -

POR_ID POR_TOP_ID_SENDING POR_TOP_ID_RECEIVING POR_ORDER_N P P P P POR_CREATED_TIMESTAM POR_USERID
---------- ------------------ -------------------- ----------- - - - - -------------------- ----------
1 1 2 26/01/582 P S N C 13-AUG-1999 22:17:11 PICKELLS

I want to find out if there is any way that I can format the first three columns (all number datatypes) and leave the rest alone "without" having to write each column out within the select statement??

I mean can can you use an sqlplus formating commands? - column...FORMAT... etc. I have tried RPAD for these 1st three columns but do not want to have to write the others as I do not want to format their output.

If you need clearification please let me know. Maybe what I want can only ne achivede via a procedure or something?????