This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes SQL *Plus client for unix Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "SQL *Plus client for unix" Watch "SQL *Plus client for unix" New topic

SQL *Plus client for unix

Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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! )
Layne Lund
Ranch Hand

Joined: Dec 06, 2001
Posts: 3061
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.

Java API Documentation
The Java Tutorial
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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!
Michael Matola
Ranch Hand

Joined: Mar 25, 2001
Posts: 1793
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

Joined: Jul 09, 2001
Posts: 1879

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,
I agree. Here's the link:
subject: SQL *Plus client for unix
It's not a secret anymore!