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

linux °²×°oracle ²ÎÊýÌáʾPORTµÄÖµNULLÎÞЧ

      µÚÒ»´ÎÔÚLinuxÉϰ²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉϰ²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOranavi£¬Í¨¹ýͼÐλ¯½çÃæ°ïÖúÓû§½«ÕâЩǰÖù¤×÷¿ì½ÝÍê³É¡£
      °´µÀÀí˵£¬Ê¹ÓÃÕâ¸ö°æ±¾µÄLinux£¬ºÜ¿ì¾ÍÄÜÍê³ÉOracleµÄ°²×°¹¤×÷ÁË£¬²¢ÇÒ֮ǰÏîÄ¿ÖÐÒѾ­ÕâÑù°²×°¹ý£¬µ±Ê±Ã»ÓгöÏÖÈκÎÎÊÌ⡣ûÏëµ½Õâ´ÎµÄ°²×°È´Åöµ½ÁËһЩÎÊÌâ¡£ÏÈÊÇÔÚʹÓÃOranavi°²×°Ê±£¬ÌáʾOracleÓû§Ã»ÓÐȨÏÞÖ´ÐÐOracleµÄ°²×°³ÌÐò£¬ÓÚÊǰÑOracleµÄ°²×°³ÌÐòÎļþȨÏÞ±ä³ÉÈ«·Å¿ª£¬½á¹û»¹ÊÇͬÑùµÄ´íÎ󡣺óÀ´×ÉѯÁËÒ»ÏÂÖ§³Ö¹¤³Ìʦ£¬·¢ÏÖÎÊÌâ³öÔÚOracle°²×°³ÌÐòÎļþµÄĿ¼¡£ÎÒÔÚÉÏ´«Oracle°²×°Îļþʱ£¬½«Æä·ÅÔÚÁË/rootϵÄÒ»¸ö×ÓĿ¼£¬OracleÓû§ÔÚ¶ÁÈ¡Õâ¸öÎļþʱÊܵ½ÁËÏÞÖÆ¡£ÓÚÊǽ«Õâ¸öÎļþ·ÅÔÚÁËrootÖ®ÍâµÄĿ¼£¬²¢ÔÚOranaviÖÐÐÞ¸ÄÎļþĿ¼λÖã¬ÎÊÌâ±ã½â¾öÁË¡£
     ÔÚ°²×°¿ìÒª½áÊø£¬´´½¨Êý¾Ý¿âʵÀýʱ£¬³öÏÖÁË“²ÎÊýPORTµÄÖµNULLÎÞЧ”ÕâÑùµÄ´íÎó£¬ÊÇÓÉEMCAÅ׳öµÄÒì³£¡£ÓÉÓÚ°²×°OracleµÄ¹ý³Ì¶¼ÊÇÓÉOranavi×Ô¶¯Íê³ÉµÄ£¬°´µÀÀí²»»á³öÏÖʲô´íÎó°¡£¿ÓÚÊÇÓÖ´´½¨ÁËÒ»¸öÐÂʵÀý£¬¿´¿´Äܲ»Äܽâ¾ö£¬¿ÉÒÔÎÊÌâÒÀ¾É¡£Ö»ÄÜgoogleÁË£¬ºóÀ´·¢ÏÖÎÊÌâµÄ¸ùÔ´ÔÚÓÚhostsÎļþ£¬Ò²¾ÍÊÇ/etc/hostsÎļþ¡£ÎļþÖУ¬ÏµÍ³µÄIPµØÖ·ÊÇ´íÎóµÄ£¬¿ÉÄÜϵͳĬÈϳÉÁíÒ»¿éÍø¿¨µÄµØÖ·ÁË£¬ÓÚÊǽ«IPµØÖ·¸ÄΪµ±Ç°Ê¹ÓõÄÍø¿¨µÄµØÖ·£¬ÎÊÌâ±ã½â¾öÁË¡£¿´À´Èκι¤¾ß¶¼Óз¸´íµÄʱºò°¡¡£


Ïà¹ØÎĵµ£º

OracleÖÐstart with¡­connect by prior×Ó¾äÓ÷¨

OracleÖÐstart with…connect by prior×Ó¾äÓ÷¨
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select … from tablename
start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = ‘HBHqfWGWPy’
connect by prior org_id = parent_id;
  ......

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨
ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ±íemp1£¬²¢ÎªÆä²åÈ벿·ÖÊý¾Ý
create table emp1
as
select * from emp where deptno = 20;
updateµôemp1ÖеIJ¿·ÖÊý¾Ý
update emp1
set sal = sal + 100,
comm = nvl(comm,0) + 50
È»ºóÎÒÃÇÊÔ×ÅʹÓÃemp1ÖÐÊý¾ÝÀ´¸üÐÂempÖÐsal ºÍ commÕâÁ½ÁÐÊý¾Ý¡£
ÎÒÃ ......

oracleÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢

oracleÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢
¿ÉÒÔ×öÒ»¸ö´¥·¢Æ÷  
  ÓÃÒÔϵķ½Ê½¿ÉÒÔ¼à¿ØµÇÈëµÇ³öµÄÓÃ戶:
´´½¨Ò»ÕżÇ¼µÇ¼TABLE£¬ÈçÏ£º 
CREATE TABLE SYSTEM.LOGIN_LOG
(
    SESSION_ID               &nb ......

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB
1 Ïà¹Ø±í¡¢ÊÓͼ
2 ÎÊÌâÃèÊö
Ϊͬʽâ¾öÒ»¸öÒòÎªÍøÂçÁ¬½ÓÇé¿ö²»¼Ñʱ£¬Ö´ÐÐÒ»¸ö³¬³¤Ê±¼äµÄSQL²åÈë²Ù×÷¡£
¼ÈÈ»ÍøÂç×´¿ö²»ºÃ£¬¾ÍÑ¡ÔñÁËʹÓÃÒ»´ÎÐÔʹÓÃJOBÀ´Íê³É¸Ã²åÈë²Ù×÷¡£ÔÚJOBÖ´ÐÐÒ»¶Îʱ¼äºó£¬ÎÒ·¢ÏÖ±»²åÈë±íÓÐЩÎÊÌ⣨²ÑÀ¢£¬µ±Ê±Ò²Ã»ÓÐÏȼì²é¼ì²é¾Í×öÁË£©¡£×¼±¸Í£Ö¹JOB£¬ÒòΪÔÚJOBÔËÐÐÇé¿öÏ£¬ÎÒ ......

linuxͼÐνçÃæ±à³Ì»ù±¾ÖªÊ¶

ÒýÓÃ
×÷Õß:GuCuiwen email:win2linux@163.com
   ºÜ¶àLINUX³õѧÕß·Ö²»Çå³þlinuxºÍXÖ®¼ä,XºÍXfree86Ö®¼ä,XºÍKDE,GNOMEµÈÖ®¼äÊÇʲô¹ØÏµ.³£³£»ìÏý¸ÅÄî,ÎÒÏëÒԱȽÏÒ×ÓÚÀí ½âµÄ·½Ê½ËµÃ÷Ò»ÏÂX,X11,XFREE,WM,KDE,GNOMEµÈÖ®¼äµÄ¹ØÏµ.ÓÉÓÚ±¾ÈËˮƽÓÐÏÞ¿ÉÄÜ´æÔÚ´íÎó,Çë¸ßÊÖÖ¸Õý.
Ò»,linux±¾ÉíûÓÐͼÐνçÃæ,linuxÏÖÔÚµÄÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ