GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Operating System  >  UNIX
Next Question 
 UNIX  |  Question 1 of 61    Print  
How do you connect to or query Oracle database from a UNIX platform.?

  
Total Answers and Comments: 4 Last Update: April 03, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Vaibhav
 
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

Above answer was rated as good by the following members:
lidaperso
August 28, 2005 01:00:29   #1  
San        

RE: How do you connect to or query Oracle database from a UNIX platform.?
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.
 
Is this answer useful? Yes | No
September 19, 2005 09:02:06   #2  
muthu        

RE: How do you connect to or query Oracle database fro...
connect username password
 
Is this answer useful? Yes | No
November 22, 2006 23:39:59   #3  
Ramakrishna        

RE: How do you connect to or query Oracle database fro...

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


 
Is this answer useful? Yes | No
April 03, 2007 07:42:14   #4  
Vaibhav        

RE: How do you connect to or query Oracle database fro...
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

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape