How to print two sql query outputs side by side in excel

Shell Programming and Scripting
1

Hi,
I have to sql queries like
select sno,sname from temptable;
select deptno,dname from depttable;

In excel i want to specify the column number to which my output should be displayed.
please help me in this...
thanks in advance...

2

could you please elaborate on the following line

i want to specify the column number to which my output

but as per the subject line , you can write a single query where these 4 columns can be accessed , as follows,

select temp.sno,
temp.sname,
dept.deptno,
dept.dname
from temptable temp ,
depttable dept
;

3

Hi Ranjan Thanks for your prompt reply....
i am using following script..to spool my output in to CSV.
I want to print these two queries output side by side.Is it possible??

spool /apps/ssta/dic_feedfiels/PrimarySecondaryHANDSETsales$tdate.CSV

select ' output1' from dual;

select circle_id,distributor_code,count(*) primary_stock
from table1
where item='HS'
and sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code;

select null from dual;
select null from dual;
select null from dual;
select null from dual;

select 'output2' from dual;

select circle_id,distributor_code,retailer_name,count(*)
from table2
where sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code,name;

spool off
EOF

4

I am not sure on the below formatted one, but please try this out and let us know,

select A.* ,
B.*
from (select circle_id,distributor_code,count() primary_stock
from table1
where item='HS'
and sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code) A,
(select circle_id,distributor_code,retailer_name,count()
from table2
where sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code,name) B ;

5

hi ranjan,
second query output is repeating for every row returned for first query.

instead of printing side by side can we print these two outputs in different sheets in same excel....

please help me out.....

6

hey prasee,

just let me know what xactly u need ???
i can optimized the query in order to return the o/p(no duplicate), in single excel sheet.

but even i am not sure how you are going to export the 2 different queries o/p to a single excel sheet with different tabs ????

can u let me know, whether table1 and table2 are same????

7

Hi ranjan,
table1 and table2 are different and we can not join those two tables.
I want to put two outputs in same excel but as output1 is very long so i want to print output2 side to it.
is there any other way to print in other sheets of excel.