page breaks with new Select statement in SQL report 1

[saketbansal]

Hi,

I am working on SQL reports. The problem is if i use two select statements in the SQL file then there are two new pages but my requirement is i want to display both the SQL outputs on same page.

I am using breaks,compute,columns and Set commands for formatting.

 

[SantaMufasa]

Saketbansal,

Without seeing the SELECTs themselves, I can only suggest that you can probably resolve your problem with a SELECT...UNION...SELECT...ORDER BY.

Let us know.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Beilstwh]

after the first select issue the following command

set embed on

This tells sqlPlus to not start the next select on a new page.

Bill
Oracle DBA/Developer
New York State, USA

 

[SantaMufasa]

Cool, Bill ! That is my "Learn-something-new-every-day" lesson. Hava

.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

I believe that if one commits to awarding a

, then it is appropriate to actually award the

, right?

Sorry, Bill, for the delay.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Beilstwh]

I didn't want to nag. Thank you.

Bill
Oracle DBA/Developer
New York State, USA