Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL *Plus client for unix

 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am looking for a SQL *Plus client ( or similar tool ).
1. Does Oracle come with a SQL *Plus client for unix?
2. If not, is there a reliable tool out there for the UNIX platform ( Preferrably NOT free --> my company likes to have someone else to blame when something goes wrong! )
Thanks,
Jamie
 
Layne Lund
Ranch Hand
Posts: 3061
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. Most certainly! However, I've only used it. I have never installed it. I suspect it comes with your Oracle installation. If it your Oracle database is already installed on a Unix server, I'd bet that SQL*Plus is already installed with it. I think the command to start it is simply "sqlplus". You may need to find the path for it, though, if it isn't in your PATH environment variable.
HTH
Layne
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
never mind. I just got the operations people to explain the business problem that generated this need and I can solve it using a very simple java utility program!
Jamie
 
Michael Matola
whippersnapper
Ranch Hand
Posts: 1821
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was about to post something almost identical to Layne's!
I've used it only a couple of times. Yes, the command to start it is "sqlplus".
Just logged in and some Oracle copyright stuff scrolled by.
I remember a developer tip sheet at work saying DO NOT log into sqlplus on Unix like this:
>sqlplus username@instance/password
because anyone can then find your password out by grepping some log.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The actual problem ( after some persistance on my part for an explanation ) was actually to dump data from an Oracle database to one in Sybase!!?? How would an Oracle SQL Editor help, I don't know, and in fact it wouldn't. So I created a little JDBC utility that performs this function. Actually, I could have probably suggested they create a DBLink or something of that sort but you just can't reason with some people!
Everyone's happy now,
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic