Differences between PL/SQL, SQL * Plus, and PL/SQL developer in spatial databases

Source: Internet
Author: User

1. First talk about the difference between pl/SQL and SQL * plus. For example, it is easy to understand:

Pl/SQL-> C ++ Language

SQL * plus-> Microsoft Visual C ++ 6.0 Compiler

Pl/SQL is the language of oracle extended SQL. It includes standard SQL, oracle extended SQL, oracle custom functions, stored procedures, triggers, packages... SQL * plus is a program that runs pl/SQL statements. You can run SQL statements in SQL * plus. It is a tool for you to manage the database system.

2. What's the difference between SQL * plus and pl/SQL developer.

SQL * plus is a command line tool provided by the Oracle database. Currently, iSql plusPL and SQL Developer are web-based graphical development tools of third parties, which are convenient and similar: oracle SQL Developer: DbVisualizernavicattoadrapid, a graphical development tool for Oracle's official Java version.

3. Differences between SQL statements, PL/SQL blocks, and SQL * Plus commands.

1) SQL statements are the language of the database for operation objects, including data definition language DDL, data manipulation language DML, Data Control Language DCL, and data storage language DSL. After an SQL statement is entered, SQL * Plus saves it in the internal buffer.

When an SQL command is entered, there are three methods to end the SQL command: enter a semicolon (;) at the end of the command line and press ENTER; use a slash (/) on a separate line (/); or empty rows.

2) PL/SQL blocks are also the data in the database as operation objects. However, since SQL does not have the process control function, in order to provide process-oriented processing functions like other languages, SQL has added process-oriented processing functions such as loops and selection, therefore, PL/SQL is formed. All PL/SQL statements are interpreted by the PL/SQL engine. You can use PL/SQL blocks to write permanent database objects such as processes, triggers, and packages.

3) the SQL * Plus command is used to format query results, set selection, edit, and store SQL commands, set the display format of query results, and set environment options.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.