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

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m*uA$_G*T[`u0
Òò´Ë,ÎÒдÕâ¸öÖ÷ÌâÒ²ÊÇÏ£ÍûÈôó¼Ò¸ü¶àµØÕÆÎÕOracleÊý¾Ý¿âµÄÌØÐÔ,´Ó¶øÔڼܹ¹Ò»¸öÐÂϵͳʱ,ÄÜ¿¼ÂÇϵͳµÄ¿ÉÀ©Õ¹,¿ÉÉìËõÐÔ,Ò²¼æ¹ËϵͳµÄЧÂʺÍÎȶ¨;ITPUB¸öÈË¿Õ¼ä'm/jSI'B
\'^H
vm
e#u!V/[0
ʹÓð󶨱äÁ¿ÊÇOracleÊý¾Ý¿âµÄÌØÐÔÖ®Ò»;ÓÚÊÇ´ó¼ÒÒªÎÊ,ΪʲôʹÓÃ,ÔõÑùʹÓÃ,ËüµÄʹÓÃÏÞÖÆÌõ¼þÊÇʲô?ÎһᰴÕÕÕâÑùµÄÏ뷨ȥ½â´ð´ó¼ÒµÄÒÉÎÊ,ÎÒÒ²»áÒÔ¾ÙÀý×ӵķ½Ê½À´»Ø´ðÕâЩÎÊÌâ;
1. ΪʲôʹÓð󶨱äÁ¿?ITPUB¸öÈË¿Õ¼ä
Mh,tMh%@ V/f
ÕâÊǽâ¾öOracleÓ¦ÓóÌÐò¿ÉÉìËõÐÔµÄÒ»¸ö¹Ø¼ü»·½Ú;¶øOracleµÄ¹²Ïí³Ø¾Í¾ö¶¨ÁË¿ª·¢ÈËÔ±±ØÐëʹÓð󶨱äÁ¿;Èç¹ûÏëÒªOracle ÔËÐмõÂý,ÉõÖÁÍêÈ«ÖÕÖ¹,ÄǾͿÉÒÔ²»Óð󶨱äÁ¿;ITPUB¸öÈË¿Õ¼äAo\}4E&Qu]
ÕâÀï¾ÙÀý˵Ã÷ÉÏÊöÎÊÌâ;ITPUB¸öÈË¿Õ¼ä t:UG)Y]
ΪÁ˲éѯһ¸öÔ±¹¤´úºÅÊÇ123,Äã¿ÉÒÔÕâÑù²éѯ:
aS B$C&Gx DR,K0
select * from emp where empno=’123’;ITPUB¸öÈË¿Õ¼ä9K9KI^0s w
ÄãÒ²¿ÉÒÔÕâÑù²éѯ:ITPUB¸öÈË¿Õ¼ägu'Pp8M @j5E{v O
select * from emp where empno=:empno;
Ïó
ÎÒÃÇÍù³£Ò»Ñù,Äã²éѯԱ¹¤’123’Ò»´ÎÒÔºó,ÓпÉÄÜÔÙÒ²²»ÓÃ;½Ó×ÅÄãÓпÉÄܲéѯԱ¹¤’456’,È»ºó²éѯ’789’µÈµÈ;Èç¹û²éѯʹÓÃÏóµÚÒ»¸ö²éѯÓï
¾ä,Äãÿ´Î²éѯ¶¼ÊÇÒ»¸öеIJéѯ(ÎÒÃǽÐËüÓ²±àÂëµÄ²éѯ·½·¨);Òò´Ë,Oracleÿ´Î±ØÐë·ÖÎö,½âÎö,°²È«¼ì²é, ÓÅ»¯µÈµÈ;ITPUB¸öÈË¿Õ¼ä3U%^,c D2Mm�XD
]
µÚ¶þ¸ö²éѯÓï¾äÌṩÁ˰󶨱äÁ¿:empno,ËüµÄÖµÔÚ²éѯִÐÐʱÌṩ,²éѯ¾­¹ýÒ»´Î±àÒëºó,²éѯ·½°¸´æ´¢ÔÚ¹²Ïí³ØÖÐ,¿ÉÒÔÓÃÀ´¼ìË÷ºÍÖØÓÃ;ÔÚÐÔÄܺÍÉìËõÐÔ·½Ãæ,ÕâÁ½ÕߵIJîÒìÊǾ޴óµÄ,ÉõÖÁÊǾªÈ˵Ä;ͨË׵㽲,¾Í²»ÊÇÒ»¸ö¼¶±ð;
T.sEeLPd0
µÚ
Ò»¸ö²éѯʹÓõÄƵÂÊÔ½¸ß,ËùÏûºÄµÄϵͳӲ¼þ×ÊÔ´Ô½´ó,´Ó¶ø½µµÍÁËÓû§µÄʹÓÃÊýÁ¿;ËüÒ²»á°ÑÓÅ»¯ºÃµÄÆäËü²éѯÓï¾ä´Ó¹²Ïí³ØÖÐÌß³ö;¾ÍÏóÒ»¸öÀÏÊó»µÁËÒ»¹øÌÀËÆ
µÄ,ϵͳµÄÕûÌåÐÔÄܽµµÍ;
¶øÖ´Ðа󶨱äÁ¿,Ìá½»Ïàͬ¶ÔÏóµÄÍêÈ«ÏàͬµÄ²éѯµÄÓû§(Õâ¾ä»°,´ó¼ÒÌýÆðÀ´±È½ÏÄÑÀí½â,ËæºóÎÒ»á¸ø³öÏêϸµÄ½âÊÍ),Ò»´ÎÐÔʹÓþͿÉÖØ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

¼Ó¿ìOracleµÄ»Ø¹öËÙ¶È

ÎÊÌâÃèÊö
1¡¢Ó¦ÓÃÁ¬½ÓÊý¾ÝÒì³£»ºÂý£¬°üÀ¨¿Í»§¶ËʹÓÃplsqlÁ¬½Ó£»
2¡¢Êý¾Ý¿âÖ÷»úcpuÕ¼ÓÃÂʾӸ߲»Ï£¬IOдÈë¾Ó¸ß²»Ï¡£
3¡¢Ö÷»úÈÕ³£Î¬»¤²Ù×÷ÏìÓ¦Âý£¬Èçman»òw£»
·ÖÎöÎÊÌâ
Øϵͳ¼°oracleÓ¦ÓÃΪʲôÏìÓ¦Âý
1¡¢ÎªÊ²Ã´ÏµÍ³Á¬wÕâô¼òµ¥µÄ²Ù×÷¶¼»á¾õµÃ¿¨ÄØ£¿
2¡¢ÎªÊ²Ã´Ã»ÓÐÈκÎÓ¦ÓýÓÈëµÄÇé¿öÏ£¬Êý¾Ý¿â»áÓдóÁ¿µÄдÈë ......

OracleÊý¾Ý¿âÓαêʹÓôóÈ«

SQLÊÇÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬Ëü ͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼­¡£ PL/SQLÖ§³ÖDMLÃüÁîºÍSQLµÄÊÂÎñ¿ØÖÆÓï¾ä¡£DDLÔÚPL/SQLÖв»±»Ö§³Ö£¬Õâ¾ÍÒâζ×÷ÔÚPL/SQL³ÌÐò¿éÖв»ÄÜ´´½¨±í»òÆäËûÈκζÔÏ󡣽Ϻà µÄPL/SQL³ÌÐòÉè¼ÆÊÇÔÚPL/SQL¿éÖÐʹÓÃÏóDBMS_SQLÕâÑùµÄÄÚ½¨°ü»òÖ´ÐÐEXECUTE IMMEDIATEÃüÁÁ¢¶¯Ì ......

Oracle/PLSQL: Lpad and Rpad Function

Oracle/PLSQL: Lpad Function£º
http://www.techonthenet.com/oracle/functions/lpad.php
RPAD and LPAD [Oracle SQL]£º
http://www.adp-gmbh.ch/ora/sql/rpad.html
ÒýÊö
In Oracle/PLSQL, the lpad function pads the left-side of a string with a specific set of characters.
The syntax for the lpad funct ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ