How do you connect to or query Oracle database from a UNIX platform.?

Showing Answers 1 - 4 of 4 Answers

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.

  Was this answer useful?  Yes

muthu

  • Sep 19th, 2005
 

connect username password

  Was this answer useful?  Yes

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions