How to Store report file in different location Using Spool in Oracle SQL Developer

See more:

SQL

Oracle

Hi ,

Declare Cnt Number;

Begin
Select Count(*) into cnt from marksheet where class='10';

IF cnt>0 Then
Spool C:\Report_10.xls
Select StudID,Score From Marksheet Where Class='10' and Grade='Pass';
Spool Off;
Else
Spool <filename>
-- Other Conditions
Spool Off;
End If;
END;


Error : line 6
encountered the symbol "c" when expecting one of the following
:= . ( @ % ;

I need Report in file like

Select Score From Marksheet Where Class='10' and Grade='Pass';

Studid Score
1002 90
1008 95

If there is alternate option other than Spool Please do suggest. I have tried this code in Oracle SQL-developer.