How can I spool a file to my client computer?

[Dery]

Hi,experts

My Oracle database locates in a Server and I access it through PL/SQL Developer in my client computer.

I want to run command file in PL/SQL Developer and spool result in my client computer. But encountered a issue. Can anyone help me? Thank you in advance!!!

My command file like this:

set linesize 200
set term off verify off feedback off pagesize 999
set markup html on entmap ON spool on preformat off
spool C:\tables.xls
@select * from alarm
spool off
exit

I can got a tables.xls in C:\. But this file is empty.

 

[Marco Kalter]

What happens if you remove the @ from the @select statement?

 

[RobertK]

>> "@select * from alarm"

that's wrong