OraFAQ Forum: SQL & PL/SQL » Executing a sql script in the command prompt and getting the output in a file

Home » SQL & PL/SQL » SQL & PL/SQL » Executing a sql script in the command prompt and getting the output in a file

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

Executing a sql script in the command prompt and getting the output in a file [message #21776]

Wed, 28 August 2002 23:21

Daniel Manohar
Messages: 7
Registered: July 2002

Junior Member

Hi,

Can u help me in this.

I want to execute the sql script from the command prompt and i should get the output in a file.

Thanx,
Daniel Manohar.

Report message to a moderator

Re: Executing a sql script in the command prompt and getting the output in a file [message #21778 is a reply to message #21776]

Thu, 29 August 2002 02:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

c:......sqlplus scott/tiger@somewhere @mysql.sql > output.txt
else
wrap the above into a myscript.bat file and
c:......myscript
same applies to unix also...

Report message to a moderator

Previous Topic:	Using DECODE function in UPDATE statement
Next Topic:	How convert NUMBER to DATE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:43:57 CDT 2024