0

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? –  Feb 13 '14 at 07:41
  • i just want unix command to connect to database without using sqlplus –  Feb 13 '14 at 09:41
  • And what do you want to do, once you are connected? –  Feb 13 '14 at 09:41
  • i need to run procedures and ldt files etc after connecting.. –  Feb 13 '14 at 10:01
  • 1
    So what is wrong with SQL*Plus then? (And what are "*ldt files*"?) –  Feb 13 '14 at 10:09
  • when i am running through java it is not detecting sqlplus command but through unix i am able to execute directly –  Feb 13 '14 at 10:19
  • 2
    So this is actually a Java problem when calling sqlplus... –  Feb 13 '14 at 10:21

1 Answers1

0

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

Community
  • 1
  • 1
Vérace
  • 854
  • 10
  • 41