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

conversion from: http://www.51testing.com /? Uid-239867-action-viewspace-itemid-103705

SQLDifferences between statements, PL/SQL blocks, and SQL * Plus commands

The SQL statement isDatabaseThe language of the operation object, including the 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. After the SQL command is entered, you can divide it by entering "; "And press enter to end, or use the slash"/"or empty line on a separate line to end.

PL/SQL blocks are also the operation objects of database objects. However, since SQL itself does not have the process control functionOthersThe language also provides the process control processing function, and adds process-oriented processing functions such as loop and selection to SQL, thus forming PL/SQL. All PL/SQL statements are interpreted by the PL/SQL engine. The PL/SQL block can be used to compile the process, trigger, package, and other database permanent objects.

the SQL * Plus command is mainly used to format query results, select, edit, and store SQL commands, set the display format of query results, and set environment options. You can edit interactive statements and "talk" with the database ".