:
1) , , :
CREATE VIEW RASH_VERT AS
SELECT DAT_RASH, TOVAR, KOLVO FROM RASHOD
2) , , , :
CREATE VIEW RASH_GORIZ AS
SELECT * FROM RASHOD WHERE TOVAR =
3) - :
CREATE VIEW RASH_VERT_GORIZ AS
SELECT DAT_RASH, TOVAR, KOLVO FROM RASHOD WHERE TOVAR =
4) :
CREATE VIEW FULL_RASHOD AS
SELECT R.DAT_RASH, R.TOVAR, R.KOLVO, T.ZENA
FROM RASHOD R, TOVARY T
WHERE R.TOVAR = T.TOVAR
UPDATE, DELETE :
1. ;
2. SELECT , DISTINCT, HAVING, , , .
INSERT :
1. , NOT NULL;
2. ;
3. SELECT , DISTINCT, HAVING, , , .
1) . , .
.
CREATE VIEW STOIM_RASH (DAT_RASH, TOVAR, STOIM) AS
SELECT R.DAT, R.TOVAR, R.KOLVO*T.ZENA
FROM RASHOD R, TOVARY T
WHERE R.TOVAR = T.TOVAR
2) CHECK OPTION. CHECK OPTION, , WHERE SELEC.
.
KOLVO, 1000
CREATE VIEW RASH_1000_CHECK AS
SELECT * FROM RASHOD
WHERE KOLVO > 1000
WITH CHECK OPTRION
, , . SQL (, PL/SQL ORACLE Transact-SQL MS SQL Server), , , C++, SQL . - - .
:
- . SELECT ;
- .
3.5.2. :
1. ;
2. ;
3. ;
4. , , , .