-
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.
-
you can do exactly the same thing ...
-
what's the problem?
Code:
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>