Geek Answers Handbook

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

I have access to an Oracle server that has databases that I would like to access. However, the machine I have access to does not have any oracle client software. Is there an alternative to oracle client software that provides functionality like MySQL mysql or psgl Postgres? I would like to be able to pop a little into the database before writing software against it.

+7
command-line database oracle client
source share
4 answers

If you download the free Oracle Instant Client , you can use any JDBC or ODBC database tool such as DbVisualizer or SquirrelSQL . These are GUI tools; I have not come across a JDBC command line tool, but there may be one.

Alternatively, there is an Instant Client version of SQL * Plus that will provide you with the Oracle sqlplus command line without a full installation of Oracle.

+8
source share

Oracle free PL / SQL IDE SQL Developer can use type 4 JDBC drivers to connect to several different types of databases, including, but not limited to, Oracle. You can use this without any Oracle client settings if you want.

+1
source share

You can try Oracle IDE SQL Developer, which is a free download . It is written in Java and is available for both Windows and Linux. It is standalone and does not require the installation of an Oracle client.

+1
source share

SQLPal ( http://www.sqlpal.com/ ) is a lightweight SqlPlus application for Windows that does not require an oracle client.

0
source share

More articles:


All Articles