San

• Aug 28th, 2005

 

We can connect to Oracle from Unix just by giving the command sqlplus at the prompt and log into Oracle using the appropriate username and password.

muthu

• Sep 19th, 2005

 

connect username password

Ramakrishna

• Nov 22nd, 2006

 

Hi All,

By writing the shallscript we can directly connected to oracle

#!/user/bin/bash

sqlplus "/as sysdba"

connect

SELECT distinct contactname,address FROM customers;

shutdown immediate

Vaibhav

• Apr 3rd, 2007

 

This should be as below:

sqlplus -s userid/password@database

In case you want to connect to SQL database

sqsh -S Servername -U username -P password

In case od SYBASE

isql -S Servername -U username -P password


Regards,
Vaibhav