> -----Original Message-----
> From: Alexander Ordonez [mailto:aordonez_at_ccss.sa.cr]
>
> I need execute any scripts in win nt like oracle in unix!!!
> example:
> sqlplus user/password << fin
> SELECT s.sid,
> s.serial#,
> p.pid,
> p.spid,
> s.osuser,
> s.machine,
> s.program
> FROM v\$session s, v\$process p
> WHERE p.addr = s.paddr
> AND s.schemaname <> 'SYS'
> ORDER BY p.spid,s.sid, p.pid, p.spid;
> fin
- Download cygwin to enable you to enter UNIX shell commands on a machine running MS Windows.
http://sources.redhat.com/cygwin/
OR
b)Enter the following at the DOS prompt:
REM running batch script
echo connect user/password > tmp.sql
echo SELECT s.sid, >> tmp.sql
echo s.serial#, >> tmp.sql
echo p.pid, >> tmp.sql
echo p.spid, >> tmp.sql
echo s.osuser, >> tmp.sql
echo s.machine, >> tmp.sql
echo s.program >> tmp.sql
echo FROM v$session s, v$process p >> tmp.sql
echo WHERE p.addr = s.paddr >> tmp.sql
echo AND s.schemaname <> 'SYS' >> tmp.sql
echo ORDER BY p.spid,s.sid, p.pid, p.spid ; >> tmp.sql
echo exit >> tmp.sql
sqlplus /nolog <tmp.sql
del tmp.sql
Received on Tue Nov 13 2001 - 17:58:06 CST
