, , . . , , , :
CREATE VIEW Datetotals
AS SELECT odate, COUNT (*), SUM (amt), AVG (amt)
FROM Orders
GROUP BY odate;
Diane SELECT Datetotals:
GRANT SELECT ON Datetotals TO Diane;
, 18, WITH CHECK OPTION . , , city , . CHECK city, , , , . , , city:
CREATE VIEW Curcities
AS SELECT *
FROM Salespeople
WHERE city IN ('London', 'Rome', 'San Jose', 'Berlin')
WITH CHECK OPTION;
, , , Curcities. , , , , , , . , , , .
, , , . , , . , . , , :
CREATE VIEW Othercities
AS SELECT *
FROM Salespeople
WHERE city NOT IN ('London', 'Rome', 'San Jose', 'Berlin')
WITH CHECK OPTION;
SELECT , , city . , .
, , , . ANSI, . ANSI ; , . , . :
|
|
, , ?
?
, , , , , ?
ANSI , SQL , . .
, , , . , , , , ( ) ( ). , , ANSI ( ).
, , , - . , DBA (DataBase Administrator), , , .