aspose file tools*
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "SQL *Plus client for unix" Watch "SQL *Plus client for unix" New topic
Author

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! )
Thanks,
Jamie
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.
HTH
Layne


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

Joined: Mar 25, 2001
Posts: 1746
    
    2
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,
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL *Plus client for unix