Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connecting to an Oracle database on the command-line without using the Oracle client software?

I have access to an Oracle server that has some databases that I would like to access. However, the machine that I have access from has none of the oracle client software. Is there any alternative to oracle's client software the provides the functionality of something like MySQL's mysql or Postgres' psql? I'd like to be able to poke around a bit in the database before writing software against it.

like image 798
Paul Wicks Avatar asked Oct 14 '08 05:10

Paul Wicks


3 Answers

If you download the free Oracle Instant Client you'd be able to use any JDBC or ODBC Database tool such as DbVisualizer or SquirrelSQL. Those are GUI tools; I've not come across a JDBC command line tool but there may be one out there.

Alternatively, there is an Instant Client version of SQL*Plus which will give you an Oracle sqlplus command line without a full Oracle install.

like image 104
Dave Webb Avatar answered Sep 24 '22 12:09

Dave Webb


Oracle's free PL/SQL IDE SQL Developer can use Type 4 JDBC drivers to connect to a number of different types of databases, obviously including Oracle. You can use that without doing any sort of Oracle client install if you so desired.

like image 45
Justin Cave Avatar answered Sep 21 '22 12:09

Justin Cave


You could try the Oracle IDE SQL Developer which is a free download. It is written in Java and is available for both windows and linux. It is self contained and doesn't require the Oracle client be installed.

like image 39
pablo Avatar answered Sep 20 '22 12:09

pablo