(. partitioning)
, .
.
:
Ø .
Ø .
Ø .
Ø , .
:
Ø .
Ø .
Ø .
Ø , .
.
(. view, , ) () , ( ), .
— .
— .
— .
— , ,
:
CREATE [RECURSIVE] VIEW _
{[( [,...])] |
[OF _ [UNDER _ [REF IS _
{SYSTEM GENERATED | USER GENERATED | DERIVED}]
[ _ WITH OPTIONS SCOPE _ ]]]}
AS _select [WITH [CASCADED|LOCAL] CHECK OPTION]
Stepanov.Code_books_1_3
| Code_book | Author | Number |
| .. | ||
| .. | ||
, 2:
//
CREATE VIEW Stepanov.Table_View
AS SELECT
Code_books_1_3.Code_book //
AS b_code, // b_code
Copies.N_books FROM
Stepanov.Copies NATURAL JOIN
Stepanov.Code_books_1_3
WHERE b_code=2
