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...

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

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 ;

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.....

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.