Oracle´æ´¢¿Õ¼ä´´½¨ÎÊÌâ

ÎÒÊǸöÐÂÊÖ  Ïë´´½¨¸öÎÞ²ÎÊýµÄ  Ϊʲô½áÊø²»ÁË 
create or replace procedure cview
begin
select nvl(a.n1,b.n1) as n1,nvl(a.n2,b.n2) as n2,n3,n4 from  a full join b
.n1=b.n1 and a.n2=b.n2;
end;
;
end;
»¹ÓÐÄܲ»ÄܸæËßÎÒ  ´æ´¢¹ý³ÌÊÇÔõôÓõĠ   ´´½¨ÍêʵĻ°  Ôõôµ÷Óà ֮ÀàµÄ 

---

Ŷ  declar ÊÇʲô¶«Î÷  Êéµê±È½ÏСÎÒĿǰûÂòµ½Êé  ËùÒÔ»ù´¡µÄ¶«Î÷¶¼²»ÖªµÀ 
Çë½ÌÀ²

---

ÒýÓÃ

create or replace procedure cview
  (po_result    out      sys_refcursor)
is
begin
  open po_result for
      select nvl(a.n1,b.n1) as n1,nvl(a.n2,b.n2) as n2,n3,n4 from  a full join b
      .n1=b.n1 and a.n2=b.n2;
end;

Äã·µ»ØµÄÊÇÒ»¸ö½á¹û¼¯¡£ÖÁÓÚµ÷Óã¬Òª¿´ÄãÓÃʲôµ÷ÓÃËü¡£
ÔÚÆäËû×Ó³ÌÐòÀֱ½ÓÕâÑùд£º
procedure cview;

лл

---

Âò±¾PL/SQL·½ÃæµÄÊé¿´¿´£¬Êý¾Ý¿â±à³Ì±ÈJAVA°¡Ê²Ã´µÄ£¬Òª¼òµ¥£¬ºÇºÇ¡£

---

ÒýÓÃ

create or replace procedure cview
  (po_result    out      sys_refcursor)
is
begin
  open po_result for
      select nvl(a.n1,b.n1) as n1,nvl(a.n2,b.n2) as n2,n3,n4 from  a full join b
      .n1=b.n1 and a.n2=b.n2;
end; <