SQL Plus 和 www.apex.oracle.com
SQL Plus 和 apex.oracle.com 的 SQL 语法是否有任何不同
从这篇文章来看，我可以假设事实并非如此，但我想确定一下。 SQL Plus 仅仅是能够连接到 Oracle 服务器的环境吗？
我问这个问题是因为我刚刚开始学习 Oracle 的 SQL 语法，并且无法从家里访问我的教师服务器。到目前为止，我找到的唯一解决方案是 Apex，因为我不打算在我的笔记本电脑上安装服务器。
Does the SQL syntax differ in any way for SQL Plus and apex.oracle.com
From this article I can assume that it doesn't, but I want to be sure. Is SQL Plus only an environment that is able to connect to an Oracle server ?
I'm asking this because I just started learning Oracle's SQL syntax and I don't have access to my faculty's server from home. The only solution I found so far is Apex since I'm not planning to install a server on my laptop.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
是的，除非您可以连接到 Oracle 数据库服务器，否则 SQL*Plus 并不是很有用。
如果您无法从家里连接到教职员工的数据库服务器，您别无选择，只能在某处安装自己的服务器。 Apex仅运行在Oracle数据库服务器上。
但是，现在并不太困难，只要您仔细按照安装说明进行操作即可。
另一种选择是在 apex.oracle.com 获取免费帐户。您将能够使用 Apex 的 SQL 界面。不过，我认为您无法使用 SQL Developer 连接到它。
或者，您可以在 Amazon EC2 上启动一个简单的预先准备的 Apex 实例。使用此选项，如果您打开相关端口 (1521)，您将能够使用 SQL Developer 连接到它。
Yes, SQL*Plus is not very useful unless you can connect to an Oracle database server.
If you cannot connect to your faculty's database server from home, you have no choice but to install your own server somewhere. Apex only runs on an Oracle database server.
However, it's not too difficult nowadays, as long as you follow the installation instructions carefully.
Another option is to get a free account at apex.oracle.com. You'll be able to use Apex's SQL interface. I don't think you can connect to it using SQL Developer, though.
Alternatively, you can start up a simple pre-prepared Apex instance on Amazon's EC2. With this option, if you open the relevant port (1521) you'll be able to connect to it using SQL Developer.
SQL 命令是相同的。它们都直接传递给数据库引擎执行。
SQL*Plus 有一堆额外的命令 （主要用于格式化输出，但也用于处理变量和数据库启动/关闭等内容）。
[Oracle 7 时代的非常旧的 SQL*Plus 版本无法将 MERGE 命令识别为 SQL，并且拒绝使用它执行任何操作。但我希望这些版本现在都已经死掉并被埋葬了。]
The SQL commands are identical. They are all passed directly to the database engine for execution.
SQL*Plus has a bunch of extra commands (mostly for formatting output, but also stuff like dealing with variables and database startup/shutdown).
[Very old versions of SQL*Plus from the Oracle 7 era don't recognize the MERGE command as SQL and would refuse to do anything with it. But I'd hope those versions are all dead and buried by now.]
SQLPlus 命令用于管理 SQLPLus 环境，与 SQL 无关。它们主要用于格式化输出或接收与 SQL 一起使用的数据以发送到服务器。
SQLPlus 是一种专有的 Oracle 产品，用于连接到 Oracle 服务器并发出命令。它正在被 SQL Developer（正式）取代。
我强烈建议您从 Oracle 下载免费 SQL Developer 程序：
http://www.oracle.com/technetwork/developer -tools/sql-developer/downloads/index.html
这是一个使用 sql 的好工具，非常容易上手（安装、创建一个新的数据库连接并开始输入 sql_ plus 一旦它填充列知道表名。
此外，如果您想格式化输出等，它可以运行大多数 sqlplus 命令。
对 oracle 模式的一个很好的视觉介绍，如果您想编写 plsql，那么它很有用。
SQLPlus commands are to manage the SQLPLus environment and have really nothing to do with SQL. They are mostly for formatting output or taking in data that is used with SQL to send to the server.
SQLPlus is a proprietary Oracle product for connecting to Oracle server and issuiung commands. It is being replaced (officially) by SQL Developer.
I strongly suggest you download the free SQL Developer program from oracle:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
it's a great tool for working with sql, pretty easy to get started (install, create a new db connection and start typing sql_ plus does fill in for columns once it know the tablenames.
Also, it can run most sqlplus commands if you want to format output, etc.
A nice visual intro to the oracle schema and useful if you want to write plsql.