Easy one: how to execute SQL scripts in MS-DOS

[l-ellison]

Hi!

When I want to execute an SQL script in Unix, I do this:
sqlplus user/passwd @/foo/file.sql > /doo/myfile.out

Then, I've got my outfile to examine.

But I am not able to do the same at MS-DOS (Windows).
Wich is the rightest method?

Best regards and thanks.

[pipo]

you can do exactly the same thing ...

[marist89]

what's the problem?

C:\scripts>type user.sql
select username from dba_users;
exit

C:\scripts>sqlplus system/manager @user.sql > user.out

C:\scripts>type user.out

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 08:59:25 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production


USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
JEFFHPC
OPS$JEFFHPC
JEFFH
USERA
USERB

9 rows selected.

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

C:\scripts>