SQL 和 SQL*Plus 有什么区别?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/1079889/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 02:40:29  来源:igfitidea点击:

What is the Difference between SQL and SQL*Plus?

sqlsqlplus

提问by Otávio Décio

What is the Difference between SQL and SQL*Plus?

SQL 和 SQL*Plus 有什么区别?

回答by Arnkrishn

SQL* Plus is a command line tool proprietary to Oracle. You can send SQL queries to the server using the tool. It can also help you format the result of a query.

SQL* Plus 是 Oracle 专有的命令行工具。您可以使用该工具向服务器发送 SQL 查询。它还可以帮助您格式化查询结果。

You should get a good head start on SQL*Plus here http://www.comp.nus.edu.sg/~ooibc/courses/sql/sqlplus.htm

您应该在此处获得 SQL*Plus 的良好开端http://www.comp.nus.edu.sg/~ooibc/courses/sql/sqlplus.htm

SQL is the query language that is used to communicate with Oracle server to access and modify the data.

SQL 是用于与 Oracle 服务器通信以访问和修改数据的查询语言。

cheers

干杯

回答by Otávio Décio

SQL is a language, SQL*Plus is a tool.

SQL 是一种语言,SQL*Plus 是一种工具。

回答by Chris Cameron-Mills

SQL*Plus is an Oracle product that you use to run SQL and PL/SQL statements.

SQL*Plus 是一种 Oracle 产品,用于运行 SQL 和 PL/SQL 语句。

回答by expEng

SQLPlus, the primary interface to the Oracle Database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data. SQLPlus delivers a full implementation of Oracle SQL and PL/SQL, along with a rich set of extensions. The exceptional scalability of the Oracle Database, coupled with the object-relational technology of SQL*Plus, allows you to develop your complex datatypes and objects using Oracle's integrated systems solution. From Oracle.com (http://www.oracle.com/technology/tech/sql_plus/index.html)

SQL Plus 是 Oracle 数据库服务器的主要接口,它为查询、定义和控制数据提供了一个功能强大且易于使用的环境。SQLPlus 提供了 Oracle SQL 和 PL/SQL 的完整实现,以及一组丰富的扩展。Oracle 数据库的卓越可扩展性与 SQL*Plus 的对象关系技术相结合,使您能够使用 Oracle 的集成系统解决方案开发复杂的数据类型和对象。来自 Oracle.com ( http://www.oracle.com/technology/tech/sql_plus/index.html)

回答by paresh sharma

sql*plus is a character based interactive tool,rhat runs in a GUI invironment. It is loaded on the client machine .

sql*plus 是一个基于字符的交互工具,rhat 在 GUI 环境中运行。它加载到客户端机器上。