is there any command string in unix which will provide access to oracle database. i dont want to use sqlplus command.
thanks for help...
-
Do you want to run SQL commands once connected? Or do you just want to check if the database is reachable?– user330315Commented Feb 13, 2014 at 7:41
-
i just want unix command to connect to database without using sqlplus– user34225Commented Feb 13, 2014 at 9:41
-
And what do you want to do, once you are connected?– user330315Commented Feb 13, 2014 at 9:41
-
1So what is wrong with SQLPlus then? (And what are "*ldt files"?)– user330315Commented Feb 13, 2014 at 10:09
-
2So this is actually a Java problem when calling sqlplus...– user330315Commented Feb 13, 2014 at 10:21
|
Show 2 more comments
1 Answer
SQLPlus has its own commands as well as being able to issue SQL and run PROCs. If Java is your thing, try SQL Developer here from Oracle - a great full-featured tool. You can also look here for open source clients - I can personally recommend SQuirreL SQL and SQL Workbench isn't bad (I've only really looked at it, YMMV).
You might also look at this question. Maybe an example of what you're trying to do might help?
HTH, Paul...
