Connecting Tech Pros Worldwide Forums | Help | Site Map

bat or cmd file to

Newbie
 
Join Date: Nov 2006
Posts: 5
#1: Nov 9 '06
Hi,

I want to log in to my DB serer through .bat or .cmd file and run the script as well.
e.g.
sqlplus uid/pass@DB
select sysdate from dual

Here the script should connect to the DB server and should return me the sysdate as well.

However, currently it is taking me to SQL prompt and forcing me to type the queries over there.

Any help would be appreciated.

Regards,
hashyaaa

Reply