oracle »ù´¡ÎÊÌâ °ïæµÄߵл°¡£¡

±ÈÈç˵ͼÊé¹ÝÓÐͼÊébook£¨id,name,prise....£©
¶ÁÕßreader(id.....)
½èÔĹØϵ borrow( bookid,readerid,date)
ÏÔÈ»´æÔÚÒ»ÕűíºÜ²»·½±ã²Ù×÷£¬·Ö¿ªÓÖ²»·½±ã²é¿´
Ç뽨Á¢¸öÊÓͼ£¬view1: select * from book,reader,borrow where book.id=bookid and reader.id=readerid
Çë°ïÎÒд³ö...ÊÓͼºÍÓï¾ä£¨Óï¾äÎÒд³öÀ´ÁË£©

ߵл£¡£¡£¡£¡£¡£¡

---

×Ô¼º¶¥ÏÂ..............

---

create or replace view xx() as ????

---

create or replace view book_reader_borrow
as
select * 
from book,reader,borrow 
where book.id=bookid and reader.id=readerid

---

ûÓÐÃèÊöÇå³þ
SQL code:
--Õâ¸ö
CREATE OR REPLACE VIEW v_borrow AS SELECT * from book,reader,borrow WHERE book.id=
borrow.bookid
AND reader.id=readerid;

---

º¹......»ù´¡°¡,¶à¿´Êé,

---

SQL code:


create view v1 as
select * from book,reader,borrow where book.id=bookid and reader.id=readerid

---

duo kan shu

---

·¹ý£¬¹Ø×¢

---

ÎÒ¶¥¿©...
{{