| 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: 1721
|
|
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
|
 |
 |
|
|
subject: SQL *Plus client for unix
|
|
|