Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡¢ÔÚÏÔʾÓαêÉÏ¿ÉÒÔÖ´ÐÐÄÄЩ²Ù×÷£¿¾ÙÀý˵Ã÷ÿһÖÖÓï¾äµÄ×÷Óá£
     *ÉùÃ÷Óαê
     *´ò¿ªÓαê
  


Ïà¹ØÎĵµ£º

¡¾×ª¡¿ Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷

Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½,¼´»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)ºÍ»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO)£¬ÔÚOracle8¼°ÒÔºóµÄ°æ±¾,OracleÇ¿ÁÐÍÆ¼öÓÃCBOµÄ·½Ê½
    RBO·½Ê½£ºÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñÑ­µÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹ ......

Oracle DropÃüÁî

--ɾ³ý¿ÕµÄ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including contents;
--ɾ³ý¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including datafiles;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace table ......

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²¹¶¡ÏÂÔØ

oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
9.2.0.4  = 3095277
9.2.0.5  = 3501955
9.2.0.6  = 3948480
9.2.0.7  = 4163445
9.2.0.8  = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189 ......

ÓëoracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ

       Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
    ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ