Oracle query on windows

investmentbnker75 · 11-08-2008, 09:57 PM

I need to be able to run a check from linux to oracle on a Windows server. Im not familiar with Oracle, does someone know what the query statement that can remotely login to oracle on windows is. I wrote something for mysql from linux to linux, which sounds similar to what im looking for which is below:

test=`mysql -P portnum --socket=/var/stanford/mysql/mysql.sock -u userid -ppasswd -e 'use db name; show tables;' | wc -l`
echo "OK - $test tables"

crabboy · 11-08-2008, 10:51 PM

Install the oracle client for Linux, setup the tnsnames.ora file with the address, port and SID of the Oracle DB and you should be able to run sqlplus to connect to the Oracle DB.

http://www.oracle.com/technology/sof...linuxsoft.html

investmentbnker75 · 11-09-2008, 09:58 AM

Not really what i was asking, everything you suggested has been done. Im looking for the actual query that gets run after that from the linux server to oracle on windows.

crabboy · 11-10-2008, 07:55 AM

If sqlplus is installed and everything setup, then it would be something like this:

Code:

$ sqlplus user/password@database @executeThis.sql

The @executeThis.sql is optional, use that is you want to run execute a sql file from the command line.

nehaandrew · 11-26-2008, 11:32 AM

Use a Free SQL IDE like "Oracle SQL Developer". It'll makes your SQL programming life a lot more easier and fun filled!

Linux