CHR(9) function
Kum KJul 9 2007 — edited Jul 9 2007Hi,
I have a Pl/sql procedure where i have written a query for the report.
I have to run the report using concurrent request in oracle Apps.
I have used the following for the COLUMN TITLES in the report.
fnd_file.put_line (fnd_file.output,
'Last Name'
||chr(12)||'First Name'
||chr(9)||'Middle'
||chr(9)||'Assignment Number'
)
And i have used the following for the values
fnd_file.put_line (fnd_file.output,vlast_name
||chr(9)||vfirst_name
||chr(9)||vmiddle_name
||chr(9)||VAssignment_number
)
But when i run the report, the formatting is not in proper order.
I want the values exactly below their titles.
Anyone any suggestion??
Thanks in advance.
--Kumar