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ÄÚ²¿Ô¤¶¨µÄһЩ¹ ......
--ɾ³ý¿ÕµÄ±í¿Õ¼ä£¬µ«Ê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 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
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 ......
Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......