| Oracle on Windows 2000 [message #50190] |
Tue, 05 March 2002 08:39  |
kiran kumar
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
In unix at command prompt we can write a sql stmt as shown below
'sqlplus user/pwd@string << EOF
select * from dept
EOF'
Is there anything similar to that in DOS ? , unix style
does not work here....
Thanks in advance
kiran
|
|
|
|
| Re: Oracle on Windows 2000 [message #50192 is a reply to message #50190] |
Tue, 05 March 2002 10:13  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
One way:
sqlplus scott/tiger@SID @sqlscript.sql
Where sqlscript.sql would contain "select * from dept;" and SID would be an entry in your tnsnames.ora file.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
