If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?????

Thanks for that nagesh - that command actually gets rid of the output; but that is not what I want.

I want to be able to say justify the first three columns output say justify the value to center or LEFT and not do naything to the rest.

I do not want to have to do this -

select (my first three columns with RPAD's), the rest of the columns
from table

as too many columns to type in .

Is there such a command(s) or way in which I can get the first three columns formatted (values centered) and get all the rest of the columns selected "without" having to type them into the select statement???

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??