Oracle version of the Sql Server “sqlcmd.exe” tool to deploy .sql scripts

Microsoft Sql Server has a command line tool called sqlcmd.exe.

You can use it to deploy .sql scripts.

I have googled and binged and found many Oracle command line tools, but I have yet to find one that will deploy a sql package.

Here is a simple example:

sqlcmd.exe -i .\MySqlScript.sql -S "MySqlServerMachine\MyInstancenName"  -E -o ".\MyOutputLogFileName.txt"

The command line will run the file "MySqlScript.sql" against a Sql Server (Instance) named "MySqlServerMachine\MyInstancenName" using integrated security ("-E") and output the results to a file named "MyOutputLogFileName.txt".

Is there a Oracle version of this tool?

Thanks!

I found "oradim", but I don't think (or cannot location documentation) that would allow that to run a .sql script.

Thanks.

==========================================================

Based on parado's response, I found the below URL:

http://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25108/xedev_sqlplus.htm#CJAGIECA

Answers


Yes, there is a sqlplus:

sqlplus user/pass@connect @scriptname

If you want output file, add to your script:

spool log.out

Need Your Help

R.java strange error

java android syntax-error r.java-file

I cannot figure out which kind of error is this.

After Calling API does not wait for Response

iphone ios

Problem is that i am call megnto api but when api return the object before that all other statements are got executed .

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.