SQL *Plus client for unix

[Jamie Robertson]

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]

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]

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]

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]

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