Skip to Main Content

SQL & PL/SQL

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!

How to remove spaces in the output of an PL/SQL report

748821Feb 18 2010 — edited Feb 18 2010
Hi,

The requirement is to develop a SQL report.

The sample code is like this

Select 'Order Number Header Id' from dual; ( This is the heading in the output of the report.)

Select order_number , header_id from oe_order_headers_all;

The output is displaying as follows
=======================
'Order Number Header Id'

1234 101
2222 102
3333 103

=======================
Now I am opening the report in excel, and there is a space appearing after the headings.
So, how can I remove the additional blank line between the headings and the data.

Thanks in advance
Mani
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2010
Added on Feb 18 2010
12 comments
4,235 views