Re: executing an SQL statement
Lois,
I can't help you much specifically unless I know more about your data. But you can use this approach to achieve the results you want.
You more than likely have variable length fields that you are writing to the report that would probably cause your columns to not line up.
The space between columns that you want to add and the alignment of the columns can both be solved using the function RPAD(str,len,padstr). str is the field contents, len is the width of the column you want including the data itself, padstr will be a space " ".
Wrap each field in the RPAD() function and you should be able to get the results you want.
Subject
Written By
Posted
Re: executing an SQL statement
April 17, 2007 05:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.