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
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
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.
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