Data Base Conexion Trough MS-DOS

[Tsilva]

_-_ Hello _-_

Is it possible to connect to a data base trough command line in MS-DOS, i´m trying to make a Batch file to connect an oracle data base 9i, but I don´t know what code to include to make the conexion, please help me.

Tsilva

[gandolf989]

It is possible, but it depends on what you want to do. You can create an .sql file and call that from the command line with sqlplus.

i.e.
sqlplus system/manager@mysid @mysqlfile.sql

But shell scripting is much easier in Unix/Linux. Dos is not a programming language. You can also do something with perl, python, etc.

What kind of script are you trying to write?

[Tsilva]

The script I´m trying to write has to execute a command to obtain some info, then I will send that info into a table of a database, I think doing this using batch files because the info is in a windows ambient, what do you suggest ?

Tsilva

[PAVB]

If you are trying to move data from Oracle to SQL Server or MS-Access I would suggest to use SQL Server or MS-Access tools.