OraFAQ Forum: Windows » Executing script using bat file

Home » Infrastructure » Windows » Executing script using bat file (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Executing script using bat file [message #431656]

Wed, 18 November 2009 23:19

abhijitsj
Messages: 6
Registered: September 2009
Location: Pune

Junior Member

Hi All,

I want to create a bat file on oracle client machine. Which will login in to oracle and execute a sql script.

Report message to a moderator

Re: Executing script using bat file [message #431663 is a reply to message #431656]

Wed, 18 November 2009 23:39

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And what is your problem in doing so?

There are many examples in Windows forum.

Regards
Michel

Report message to a moderator

Re: Executing script using bat file [message #431680 is a reply to message #431656]

Thu, 19 November 2009 02:06

Littlefoot
Messages: 21761
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Something like this:

-- TEST.SQL
select * from dept;

exit;

REM test.bat
sqlplus -s scott/tiger@ora10 @test.sql

M:\>test

M:\>sqlplus -s scott/tiger@ora10 @test.sql

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

M:\>

Report message to a moderator

Previous Topic:	Encount ORA-00600 when setting audit_trail parameter
Next Topic:	How to call stored procedures by batch file (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 17:34:10 CDT 2023