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¡¢ÔÚÏÔʾÓαêÉÏ¿ÉÒÔÖ´ÐÐÄÄЩ²Ù×÷£¿¾ÙÀý˵Ã÷ÿһÖÖÓï¾äµÄ×÷Óá£
*ÉùÃ÷Óαê
*´ò¿ªÓαê
 
Ïà¹ØÎĵµ£º
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 ......
¡¡¡¡¡¡
һֱûÓÐÍæ¹ýͨ¹ýÃüÁîÔÚDOSÏÂÖ´ÐÐoracleÊý¾Ý¿â,ËäÈ»¸ã¿ª·¢2ÄêÁË£¬»òÐíÕâÆªÎÄÕÂдµÃ±È½Ï·ôdz£®µ«»òÐí¶ÔÄÄЩ¸Õ¸ÕѧORACLEµÄÅóÓÑ»¹ÊÇÓÐÒ»¶¨°ïÖúµÄ£®
¡¡¡¡¡¡Í¨¹ýÃüÁîÄܹ»ºÜºÃµÄÖ´ÐдóÅúÁ¿Êý¾Ý½Å±¾£§½Å±¾£®sql£§£®±ÜÃâͨ¹ýPLSQL DeveloperÖ´ÐÐÅúÁ¿Êý¾ÝÔì³ÉµÄËÀ»úÇé¿ö£®
¶þ ......
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 ......
ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......