Howto start a sql script from windows

[SysAdminUnix]

How do I start a commandfile in windows to get data/commands in/out oracle?

I know that it has to be something like a command file containing a string like "sqlplus@example.sql". In the file example.sql there is a string like "select * from dual;". I'm at the moment only familiar with the Unix style "<EOF"

It should run in windows 2000 prof against a 9i db.

 

[sem]

Passing @scripname parameter to sql*plus causes it to execute commands containd in that file. Though the first parameter sql*plus expects is login/password@database, i.e. connect string. Of course you may log in from the script itself, but in this case you should launch sql*plus with /nolog switch.

Regards, Dima

http://seminihin.narod.ru