(). . , . , 2, 1. 3 1 2.
: . , 1:
| , 15 , |
:
: 1 , ( ) . , 2:
, . ( ) ( ). ( ). 2- , :
, , ( ) ( , ).
: , 2 ( 1).
:
. 3:
, , -- (, - ). :
|
|
|
SQL
(Structured Query Language, SQL). SQL 70- , . , (, , ..) ( ).
SQL , SQL2. SQL2 SQL, ( ).
SQL : . . , SQL. , , SQL.
, . , Oracle SQL*Plus, MS SQL Server Query Analyzer. SQL-, . Oracle SQL*Plus:
. 1.
API-, SQL- .
SQL
, SQL , , , , , , .
SQL 40 ( ) .
SQL- (), , . . , 500 .. , , :
SELECT TabNum FROM Employees WHERE Salary>500
:
- SELECT ();
- FROM, WHERE (, );
- Employees ;
- TabNum, Salary .
.
|
|
|
.
(Data Definition Language DDL)
DDL- , . , , , ( , .).
DDL-:
| CREATE TABLE | |
| DROP TABLE | |
| ALTER TABLE |
(Data Manipulation Language DML)
DML- , , ,
.
DML-:
| SELECT | |
| INSERT | |
| DELETE | |
| UPDATE |
(Transaction Control Language TCL)
TCL- , DML-. DML- , . , - . .
TCL-:
| COMMIT | |
| ROLLBACK | |
| SET TRANSACTION |
(Data Control Language DCL)
DCL- :
| GRANT | |
| REVOKE |
SQL
