Answer by
worker7093 (11)
CONNECT scott/tiger
SPOOL C:\emp. Lst
set linesize 100
set pagesize 50
select *
from emp;
spool off
exit;
create file "c:\get_emp. bat" containing
sqlplus /nolog @C:\emp. sql
UNIX/Linux
CONNECT scott/tiger
SPOOL /u01/emp. Lst
set linesize 100
set pagesize 50
select *
from emp;
spool off
exit;
create shell script"/u01/get_emp. ksh" containing
#! /bin/ksh
sqlplus /nolog @/u01/emp. sql