Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¡¢ÔÚÏÔʾÓαêÉÏ¿ÉÒÔÖ´ÐÐÄÄЩ²Ù×÷£¿¾ÙÀý˵Ã÷ÿһÖÖÓï¾äµÄ×÷Óá£
     *ÉùÃ÷Óαê
     *´ò¿ªÓαê
  


Ïà¹ØÎĵµ£º

redhat5Éϰ²×°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 ......

oracleÊý¾Ý¿âͨ¹ýÃüÁîµÇ¼£¬Ö´ÐÐSQLÓï¾ä

¡¡¡¡¡¡
        һֱûÓÐÍæ¹ýͨ¹ýÃüÁîÔÚDOSÏÂÖ´ÐÐoracleÊý¾Ý¿â,ËäÈ»¸ã¿ª·¢2ÄêÁË£¬»òÐíÕâÆªÎÄÕÂдµÃ±È½Ï·ôdz£®µ«»òÐí¶ÔÄÄЩ¸Õ¸ÕѧORACLEµÄÅóÓÑ»¹ÊÇÓÐÒ»¶¨°ïÖúµÄ£®
¡¡¡¡¡¡Í¨¹ýÃüÁîÄܹ»ºÜºÃµÄÖ´ÐдóÅúÁ¿Êý¾Ý½Å±¾£§½Å±¾£®sql£§£®±ÜÃâͨ¹ýPLSQL DeveloperÖ´ÐÐÅúÁ¿Êý¾ÝÔì³ÉµÄËÀ»úÇé¿ö£®
¶þ ......

Oracle Flashback Technology


Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......

ORACLEÎﻯÊÓͼ ¶¨Î»µ¼ÖÂÎﻯÊÓͼÎÞ·¨¿ìËÙˢеÄÔ­Òò


ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ