-
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?????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|