database 在不使用 Oracle 客户端软件的情况下通过命令行连接到 Oracle 数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/200056/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Connecting to an Oracle database on the command-line without using the Oracle client software?
提问by Paul Wicks
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.
我可以访问 Oracle 服务器，该服务器包含一些我想访问的数据库。但是，我可以访问的机器没有任何 oracle 客户端软件。oracle 的客户端软件是否有任何替代方案可以提供诸如 MySQL 的 mysql 或 Postgres 的 psql 之类的功能？在针对它编写软件之前，我希望能够在数据库中稍微浏览一下。
回答by Dave Webb
If you download the freeOracle Instant Clientyou'd be able to use any JDBC or ODBC Database tool such as DbVisualizeror SquirrelSQL. Those are GUI tools; I've not come across a JDBC command line tool but there may be one out there.
如果您下载免费的Oracle Instant Client，您将能够使用任何 JDBC 或 ODBC 数据库工具，例如DbVisualizer或SquirrelSQL。那些是 GUI 工具；我没有遇到过 JDBC 命令行工具，但可能有一个。
Alternatively, there is an Instant Client version of SQL*Pluswhich will give you an Oracle sqlpluscommand line without a full Oracle install.
或者，还有一个SQL*Plus的Instant Client 版本，它可以为您提供一个 Oraclesqlplus命令行，而无需完整的 Oracle 安装。
回答by Justin Cave
Oracle's free PL/SQL IDE SQL Developercan 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.
Oracle 的免费 PL/SQL IDE SQL Developer可以使用 Type 4 JDBC 驱动程序连接到许多不同类型的数据库，显然包括 Oracle。如果您愿意，您可以使用它而无需进行任何类型的 Oracle 客户端安装。
回答by pablo
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.
您可以尝试免费下载Oracle IDE SQL Developer 。它是用 Java 编写的，可用于 windows 和 linux。它是自包含的，不需要安装 Oracle 客户端。
回答by Leigh Riffel
SQLPal (http://www.sqlpal.com/) is a lightweight SqlPlus like application for Windows that does not require the oracle client.
SQLPal ( http://www.sqlpal.com/) 是一个轻量级的 SqlPlus 类 Windows 应用程序，不需要 oracle 客户端。
