2 SQL's in Single statment & write NULL values in the record set also to Excel sheet

[prasadsbrk]

Hi,

How to execute 2 SQL statments in single resultset & i need to write the RS values to excel including NULL's
like
set rowcount 10;
select * from emp where deptno = 10 order by empno;

such that i need top 10 records only.

Thanks in advance ....