Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Right Padding of space in the header part of the Report.

NihaappsJun 10 2010 — edited Jun 10 2010
Hi ,
I have developed one orcale report where in the header I ahave one string whcich contain "ReportRunDateand one hard code value like 1010"
During output it is displying like 101020100610 but I want to add some space after this string like the string should be "101020100610 " In example I have added 10 spaces . But in my case the length of this sting should be 283 charecter.
I wrote this code at before reprt trigger and assigning the value in to aplace holder column but it is not working it is Displaying only the string nwithout the space.
Code is like this

:C_FILE_HEADER := '0101'
|| to_char(sysdate,'yyyymmdd')
|| RPAD(' ',271,' ');

Could any one please help me out on this . It is urgent it is like one production issue.

Advance thanks for ur help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2010
Added on Jun 10 2010
10 comments
1,314 views