Oracle»ù´¡ÊÔÌâ£¨ÃæÊÔ»ù±¾£©
1¡¢´æ´¢¹ý³ÌºÍº¯ÊýµÄÇø±ð¡£
£¨1£©¡¢´æ´¢¹ý³ÌÊÇ×÷ΪPL/SQLÓï¾äÖ´ÐУ¬¶øº¯ÊýÊÇ×÷Ϊ±í´ïʽµÄÒ»²¿·Öµ÷Óã»
£¨2£©¡¢´æ´¢¹ý³ÌÔÚ¹æ¸ñ˵Ã÷Öв»°üº¬returnÓï¾ä£¬¶øÔÚº¯ÊýµÄ¹æ¸ñ˵Ã÷Õâ°üº¬return×Ӿ䣻
(3)¡¢´æ´¢¹ý³Ì²»·µ»ØÖµ£¬¶øº¯Êý±ØÐë·µ»ØÖµ£»
£¨4£©¡¢ÔÚ´æ´¢¹ý³ÌÖпÉÒÔ°üº¬returnÓï¾ä£¬µ«²»·µ»ØÈκÎÖµ£¬ËûÖ»±íʾÍ˳ö´æ´¢¹ý³Ì£¬¶øº¯ÊýÖбØÐë°üº¬Ò»¸öreturnÓï¾ä£»
2¡¢´¥·¢Æ÷·ÖΪÊÂǰ´¥·¢ºÍʺ󴥷¢£¬ÕâÁ½ÖÖ´¥·¢ÓкÎÇø±ð¡£Óï¾ä¼¶´¥·¢ºÍÐм¶´¥·¢ÓкÎÇø±ð¡£
ÊÂǰ´¥·¢ÊÇÔÚÊý¾ÝûÓÐдÈëÊý¾Ý¿âʱ¾Í´¥·¢£¬¶øÊº󴥷¢ÊÇÔÚ°ÑÊý¾ÝдÈëÊý¾Ý¿âºóÔÙ´¥·¢
Óï¾ä¼¶´¥·¢ÖµËùÓеÄÏàͬµÄÓï¾äÖ»´¥·¢Ò»´Î£¬¶øÐм¶´¥·¢ÊÇÿִÐÐÒ»ÌõÓï¾ä¾Í´¥·¢Ò»´Î¡£
3¡¢¸ù¾Ýstudents±í(stuID,stuName,stuSex,stuAge,stuTel)±àдһ¸ö´æ´¢¹ý³Ì£¬½«students±íÖеÄѧÉúIDºÅ´«µÝ¸øÕâÒ»¹ý³Ì£¬²¢Ïòµ÷ÓÃÓ¦ÓóÌÐò·µ»ØÑ§ÉúµÄÐÕÃûºÍµç»°ºÅÂë¡£ÔÙ±àдһ¸ö¾ßÓйý³Ìµ÷ÓõÄÄäÃû¿é¡£
´æ´¢¹ý³Ì
create or replace procedure pro_stu(id in number,stuname out varchar2,
stutel out varchar2) as
begin
select A.stuname,A.stutel into stuname,stutel from students A
where A.stuid=id;
end pro_stu;
ÄäÃû¿é£º
declare
stuid number(3);
stuname varchar2(12);
stutel varchar2(15);
begin
stuid:=&stuid;
pro_stu(stuid,stuname,stutel);
DBMS_OUTPUT.PUT_LINE('ÐÕÃû£º' || stuname);
DBMS_OUTPUT.PUT_LINE('µç»°£º' || stutel);
EXCEPTION
when NO_DATA_FOUND then
DBMS_OUTPUT.PUT_LINE('δÕÒµ½·ûºÏÌõ¼þµÄÊý¾Ý£¡£¡');
end;
4¡¢ÔÚÏÔʾÓαêÉÏ¿ÉÒÔÖ´ÐÐÄÄЩ²Ù×÷£¿¾ÙÀý˵Ã÷ÿһÖÖÓï¾äµÄ×÷Óá£
*ÉùÃ÷Óαê
*´ò¿ªÓαê
 
Ïà¹ØÎĵµ£º
Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½,¼´»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)ºÍ»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO)£¬ÔÚOracle8¼°ÒÔºóµÄ°æ±¾,OracleÇ¿ÁÐÍÆ¼öÓÃCBOµÄ·½Ê½
RBO·½Ê½£ºÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹ ......
red hat enterprise linux 5 »·¾³ÏÂOracle10g
Ò»¡¢°²×°Ç°µÄ×¼±¸¹¤×÷
1¡¢ÏÂÔØoracle_database_10.2.0.1.0 for linux °²×°³ÌÐò£º
ÏÂÔØµØÖ·£ºhttp://202.197.127.197/libweb/down.asp£¨×¢Òâ°²×°ÎļþµÄ°æ±¾ºÅ£©
2¡¢½âѹÈí¼þ£º
½«ORACLE°²×°Ñ¹Ëõ°ü½âѹ£¬µÃµ½oracle_database_10.2.0.1.0.Ŀ¼
3¡¢ÉèÖúËÐIJÎÊý£º
ÔÚ/etc/sy ......
Fedora10 É쵀 Oracle 10.2.0.1 ÊÖ¹¤½¨¿âÈ«¹ý³Ì
NOTE:
(1)¼Ç×ÅÒªÔÚoracleÓû§Ï¶ø²»ÊÇrootÏÂÖ´ÐÐÕâЩ²Ù×÷£¬·ñÔòÒòΪȨÏÞµÄÎÊÌâ»á´øÀ´ÎÞÇîÎÞ¾¡µÄÂé·³
(2)Òª¼ì²é¹ý³ÌÖÐËùÓгöÏÖµÄĿ¼Ãû¶¼ÊǶÔÓ¦ÕýÈ·ÇÒÓÐЧµÄ£¬·ñÔò¼¸ºõûÓпÉÓõĴíÎóÐÅÏ¢À´²éÕÒÕâÖÖ´íÎó
(3)Òª ......
¶ÔÓÚ¸Õ½Ó´¥unixµÄÈ˶øÑÔ,ÀûÓùܵÀ½«¸÷ÖÖÃüÁî×éºÏÔÚÒ»ÆðÀ´ÊµÏÖij¸ö¹¦ÄÜ,ÊDZȽÏÄÑÊÊÓ¦µÄÒ»¼þÊÂÇé,ÏÂÃæ£¬ÎÒ¾ÍÓÃÒ»¸ö¾ßÌåµÄÀý×Ó,Ïêϸ½²ÏÂ×ÅÀïÃæµÄÓ÷¨ºÍ˼·.¿´¿´µ½µ×ÎÒÃǰÑÃüÁî¶¼°óÔÚÒ»Æð,unix¶¼×öÁËʲô.
¾ÍÓÃÒ»¸öoracle¹ÜÀíÖÐ,¿ÉÄÜ»áÓöµ½µÄÀý×Ó°É,Èç¹ûoracle¹ÒÁË£¬ ......