Oracle´æ´¢¹ý³Ì

 Oracle´æ´¢¹ý³Ì¹¦ÄÜÇ¿´ó£¬ËûÖ÷ÒªµÄ×÷ÓÃÓÐÒÔϼ¸µã:
1.¿ÉÒÔÅúÁ¿Ö´ÐÐsqlÓï¾ä£¬ÌṩÄÚÖõÄÊÂÎñÖ§³Ö£¬Í¬Ê±Äܹ»Ìá¸ßÊý¾Ý¿â²Ù×÷µÄЧÂÊ¡£
2.¿Í»§¶Ë³ÌÐòÒÀ¾Ý´æ´¢¹ý³ÌÃûÀ´µ÷Óã¬Ìṩ³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
3.Ìṩ¸´ÔÓµÄSQLÓï¾äÂß¼­Ö§³Ö¡£
Óï·¨½á¹¹°üÀ¨¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£
1£©²»´ø²ÎÊý£º
Create or replace procedure NoparProcedureName
is
begin
delete from tablename  a where a.id='';
delete from tablename b where b.id=''; 
exception
end;
2)´ø²ÎÊý£º
Create or replace procedure ParProcedureName(key_id in char)
is
begin
delete from tablename  a where a.id=key_id;
update tablename b set b.name='²âÊÔ' where b.id=key_id; 
exception
end;
3)´ø²ÎÊýº¬¸³Öµ
Create or replace procedure MyProcedureName(key_id in char,isal out varchar)
is icount number ;
begin
select count(*) into icount from emp where sal>isal ;
if icount==1 then ...
esle
...
end if ;
end