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

OracleÈÏÖ¤µÄ¼ÛÖµ

OracleµÄÿÃÅÈÏÖ¤¿¼ÊÔÊÇ135ÃÀ½ð£¬¹²ÓÐ5ÃÅ¿¼ÊÔ£¬ËùÓеĿ¼ÊÔ·ÑÓÃÔÙ¼ÓÉÏһЩÆäËü·ÑÓã¨Êé¡¢ÅàѵµÈµÈ£©£¬ÒªÏëͨ¹ýOracleÈÏÖ¤¿¼ÊÔ±¾Éí¾ÍÊÇÒ»±Ê²»Ð¡µÄͶ×Ê£¬µ«ÊÇ£¬´Ó½ñÌìµÄ¾ÍÒµÊг¡À´¿´£¬µÃµ½µÄ»Ø±¨»¹ÊÇÖµµÃµÄ¡£
ºÜ¶àÈ˶¼Ï£ÍûÔÚITÁìÓòµÃµ½ÏñOracle DBAÄÇÑùµÄ¸ßн——Äêн75£¬000$µ½140£¬000$.¶ÔÓÚOracle DBAµÄ×ÊÉîÈËÊ¿À´½²£¬ËûÃǵÄÄêнÒѾ­Õǵ½ÁË300£¬000$.ºÜ¶àѧԱ¶¼ÈÏΪͨ¹ýÁËOracleµÄÈÏÖ¤£¬Ò²¾ÍµÃµ½ÁËOracleÊý¾Ý¿âÁìÓòµÄͨÐÐÖ¤¡£µ«ÊÇ£¬OracleÈÏÖ¤Ö»ÊÇÄÇЩÓÐÔ¶¼û׿ʶµÄÀϰåµÄÆÀÅбê×¼Ö®Ò»¡£
ºÜ¶àITרҵÈËÊ¿¶¼²»ÏàÐÅOracle DBAÔÚ³ý¼¼ÊõÖ®Í⻹Óиü¸ßµÄº¬½ðÁ¿¡£Í¨³£Çé¿öÏ£¬Oracle DBA¿ÉÒÔ¸ºÔðÊý¾Ý¿âÉè¼Æ¡¢ÔËÐС¢±¸·ÝÒÔ¼°»Ö¸´£¬Í¬Ê±»¹ÒªÃÜÇйØ×¢Õû¸öÏîÄ¿¿ª·¢µÄÈ«¹ý³Ì¡£Òò´Ë£¬Ò»Ãû³É¹¦µÄOracle DBA¼ÈÒª¾ßÓйýÓ²µÄ¼¼Êõˮƽ£¬ÓÖÒªÓгöÉ«µÄЭµ÷ÄÜÁ¦£¬Í¬Ê±£¬¶ÔÓÚ²Ù×÷ϵͳÒÔ¼°¼ÆËã»úÀíÂÛµÄÉîÈëÁ˽âÒ²ÊDZØÐëµÄ¡£Òò´Ë£¬DBA±ØÐëÒª¾ßÓмÆËã»úרҵ¡¢Í¨ÐÅרҵ¡¢ÉÌÎñ¹ÜÀíרҵµÄѧʿ»ò˶ʿѧλ¡£
 ¶øOCPÈÏÖ¤¿¼ÊÔÔÚOracle¹ÜÀíÁìÓòÄÚÊǺâÁ¿Ò»¸öÈËרҵ¼¼ÊõË®Æ½ÕÆÎճ̶ȵÄÒ»¸öºÜºÃµÄ±ê×¼£¬µ«ÓÐÁËOCPÖ¤Êé²¢²»µÈÓÚÄã¾Íѧ»áÁËOracleרҵ¼¼Êõ£¬ºÜ¶à»ñµÃOCPÖ¤Ê飬²»Äܹ»ÍêÈ«Àí½âOracle¹ÜÀíµÄËùÓиÅÄî¡£ÓÐÖ¤Êé²»Ò»¶¨¾ÍÓÐ×ʸñ
    ¼Çס£¬OracleÈÏÖ¤Ö¤ÊéÖ»ÊÇÈùÍÖ÷Á˽⵽À´Ó¦Æ¸µÄÈËͨ¹ýÁËOracleÊý¾Ý¿â·½ÃæµÄ¼¼Êõ¿¼ÊÔ¡£¶øÊµ¼ÊÉÏ£¬OracleÈÏÖ¤Ò²Ö»ÊǺâÁ¿Ò»¸öӦƸÕßµÄÒ»¸ö±ê×¼Ö®Ò»£¬ÆäËûµÄ±ê×¼»¹ÓУº
³öÉ«µÄ½»¼ÊÄÜÁ¦£ºOracle DBAͨ³£¶¼ÒªºÍITÐÐÒµµÄ¼¼Êõר¼Ò´ò½»µÀ£¬Òò´Ë£¬Ëû»òËý¾Í±ØÐëÄܹ»ÎªËùÓзÃÎÊOracleÊý¾Ý¿âµÄ¿ª·¢ÈËÔ±»ò³ÌÐòÔ±ÇåÎúÃ÷Á˵ĽâÊÍOracle¸ÅÄî¡£ÓÐЩʱºò£¬Oracle DBAÒ²ÊÇÒ»Ãû¹ÜÀíÈËÔ±£¬Òò´Ë£¬Ò²Í¬ÑùÒªÇóËûÔÚ²ÎÓëÕ½ÂÔ·¢Õ¹¼Æ»®ÒÔ¼°Êý¾Ý¿âÉè¼ÆÉÏÒªÓгöÉ«µÄ½»¼ÊÄÜÁ¦¡£
´ó¶àÊý³É¹¦µÄOracleרҵÈËÊ¿¶¼ÒªÇóÓɼÆËã»ú»òÐÅϢϵͳרҵѧʿѧλ¡£¶ÔÓÚ¸ü¸ßµÄְ룬±ÈÈçOracle DBA£¬ºÜ¶à¹ÍÖ÷¶¼ÒªÇóÓɼÆËã»úרҵ˶ʿѧλ»òMBA.
 Êµ¼ù¾­Ñ飺ÕâÊÇÓÐÁËOCPÖ¤ÊéµÄÐÂÈËÃÇ×îµ£ÐĵÄÒ»¼þÊÂÇé¡£ºÜ¶àÓÐÁËOCPÖ¤ÊéÓÖûÓй¤×÷¾­ÑéµÄÈ˶¼ÔÚ±§Ô¹Ã»ÓÐOCPÖ¤Êé¾Í²»»áÓй¤×÷¾­Ñ飬ûÓй¤×÷¾­Ñé¾Í²»»áÓй¤×÷¡£ÕâÊÇÏÖÔÚÈ˲ÅÊг¡ÉÏÒ»¸öºÜ¼¬ÊÖµÄÎÊÌâ¡£
OCP²¢²»ÄÜÍêÈ«ºâÁ¿Ò»¸öÈ˵Äʵ¼Êˮƽ£¨×îÖØÒªµÄÊDz»ÄÜÆÀÅÐËûµÄ¹¤×÷¾­Ñ飩£¬ËûÖ»ÊÇΪ·ÇITÐÐÒµÈËÊ¿½øÈëOracleÁìÓòÌṩһ¸ö·½·¨¡£
 
¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄÓµÓÐÊ®ÄêITÅàѵ¾­Ñ飬רעÖйú¸ß¶ËITÅàѵÊÇÖйú¸ß¶ËITÅàÑ


Ïà¹ØÎĵµ£º

oracle²ÎÊýnls_length_semantics

oracle²ÎÊýnls_length_semantics£º
ĬÈÏ£ºbyte
create table test  (a varchar(20),b number)
 µÈͬÓÚ£º
CREATE TABLE HXG.TESTNLS
(
  A  VARCHAR2(20 BYTE),
  B  NUMBER
)
varchar(20)ÓɲÎÊýnls_length_semantics¿ØÖÆ
/////////////////////////////////////////////////////// ......

hacking oracle±Ê¼Ç

###author:hiphop###
###qq:70381908###
ΪʲôҪ¹Ø×¢ Oracle ?
ÒòΪOracle ±»´óÁ¿ÆóÒµËùʹÓÃ,ÓÐÐí¶àÄ¿±ê¿ÉÒÔÑ¡ÔñÀ´ÉøÍ¸
Ðí¶àÆóÒµ¶¼Ã»ÓиüÐÂÇÒÓÐDZÔڵķ½ÏÕ!
ÌáȨ·Ç³£¼òµ¥,ÈÝÒ×Äõ½shell!!
¶ÁÁËblackhat paper ÈÃÎÒ¿ªÊ¼À´Ñо¿Oracle
ÒòΪËûÖ»½²µ½Ò»Ð¡²¿·Ý ÕæÕý°²È«ÎÊÌ⻹ÓкܹãµÄ
Ö»ÊǹúÄÚºÃÏñºÜÉÙÍÚ¾ò
ÒòΪÓöµ½ ......

Oracle 10g RAC On Linux Using NFS

http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......

OracleÊý¾ÝÀàÐͼò½é¡¾×ªÌù¡¿

OracleÊý¾ÝÀàÐͼò½é
¡¡¡¡Ò»¡¢¸ÅÊö
¡¡¡¡ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿£¨SCALAR£©¡¢¸´ºÏ£¨COMPOSITE£©¡¢ÒýÓã¨REFERENCE£©ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ£¬ÏÂÃæÏêϸ½éÉÜËüÃǵÄÌØÐÔ¡£
¡¡¡¡¶þ¡¢±êÁ¿£¨SCALAR£©
¡¡¡¡ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿É ......

oracle UPDATE ¶à±í¹ØÁª¸üÐÂ

update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
-- update ³¬¹ý2¸öÖµ
update customers a
set (city_name,customer_type)=(select b.city_name,b.customer_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ