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

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.