ÇáÓáÇã Úáíßã æÑÍãÉ Çááå æÈÑßÇÊå
ÇáÏÑÓ ÇáËÇáË ÚÔÑ

ÓäÊäÇæá Ýí åÐÇ ÇáÏÑÓ Úä ßíÝíÉ ÇäÔÇÁ Çá Views æÇáÊÚÇãá ãÚåÇ ....


ÊÚÑíÝ Çá views
åí ÚÈÇÑÉ Úä ÇÓÊÚáÇã äÓÊØíÚ æÖÚå Úáì ÌÏæá Çæ ÇßËÑ ãä ÌÏæá ÈÍíË áÇ äÓÊØíÚ ÇáÇÖÇÝÉ Çæ ÇáÍÐÝ Çæ ÇáÊÚÏíá ãä ÎáÇáå ÇÐÇ åæ ÚÑÖ æíÓÇÚÏ Ýí ÇäÔÇÁ ÇÓÊÚáÇãÇÊ ËÇÈÊÉ Úáì ÇáÌÏÇæá

ÞÇÚÏÉ ÇäÔÇÁ Çá View

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;

ãËÇá

CREATE VIEW sup_orders AS
SELECT supplier.supplier_id, orders.quantity, orders.price
FROM supplier, orders
WHERE supplier.supplier_id = orders.supplier_id
and supplier.supplier_name = 'IBM';

æØÑíÞÉ ÚÑÖ Çáview æÚÑÖ ãÍÊæíÇÊåÇ åí

SELECT *
FROM sup_orders;

æíãßä ÇáÊÍÏíË Úáì Çá view ÈÏæä ÍÐÝåÇ

æÐáß ÍÓÈ ÇáÞÇÚÏÉ ÇáÊÇáíÉ

CREATE OR REPLACE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;

ãËÇá

CREATE or REPLACE VIEW sup_orders AS
SELECT supplier.supplier_id, orders.quantity, orders.price
FROM supplier, orders
WHERE supplier.supplier_id = orders.supplier_id
and supplier.supplier_name = 'Microsoft';

æÍÐÝ Çá view
íÊã ÍÓÈ ÇáÞÇÚÏÉ ÇáÊÇáíÉ

DROP VIEW view_name;

ãËÇá

DROP VIEW sup_orders;

æåäÇß ØÑíÞÉ áãÚÑÝÉ Çá view Ýí schema ãÚíäå
ÍÓÈ ÇáÊÇáí
íæÌÏ Ýí íæÒÑ sys ÌÏæá ÇÓãå dba_views
ãä ÎáÇá åÐÇ ÇáÌÏæá ããßä Çä ÊÓÊÚÑÖ Çá view
æáÃí íæÒÑ ÊÇÈÚ æãÇ åí ÌãáÉ Çá select ÇáÊí ãæÌæÏÉ Ýí åÐÇ Çáviews