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

OracleµçÁ¦ÐÐÒµ½â¾ö·½°¸ ¸¶Ê×ê¿

ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾­Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾­¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾­ÊÜ×ÅÇ°ËùδÓеÄѹÁ¦¡£
    Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØиÄ×飬»®·ÖΪ¹ú¼ÒµçÍø¹«Ë¾ºÍÖйúÄÏ·½µçÍøÓÐÏÞ¹«Ë¾ÒÔ¼°Öйú»ªÄܼ¯ÍŹ«Ë¾¡¢Öйú´óÌƼ¯ÍŹ«Ë¾¡¢Öйú»ªµç¼¯ÍŹ«Ë¾¡¢Öйú¹úµç¼¯ÍŹ«Ë¾¡¢ÖйúµçÁ¦Í¶×ʼ¯ÍŹ«Ë¾µÈ5¼Ò·¢µç¹«Ë¾¡£ÖØ×éºóµÄÈô¸É·¢µç¼¯ÍÅ£¬ÈçºÎ½øÐм¯ÍÅ»¯¹ÜÀí£¿ÈçºÎ½«·ÖÉ¢µÄ£¬¸÷×ÔΪÕþµÄ·¢¡¢Êä¡¢Åä¡¢ËÍϵͳÓÐЧµØ½øÐÐÕûºÏ£¬Í³Ò»µØµ÷ÖÃ×ÊÔ´£¬¼ÓÇ¿È«Ãæ¼à¹Ü£¬Ìá¸ß×ۺϾºÕùÁ¦£¬³ÉΪ·¢µçÆóÒµËùÃæÁÙµÄ×îΪÑϾþµÄÌôÕ½¡£
    ÁíÒ»·½Ã棬ÎÒ¹ú¸ßËÙ·¢Õ¹µÄ¹úÃñ¾­¼Ã¶ÔµçÄÜÔ´³ÊÏÖ³öÁË“Ñ©±À”ʽµÄÐèÇó¡£½ü¼¸Äê¹úÄÚ¸÷ÐÐÒµ¶ÔµçÄÜÔ´µÄÐèÇóÁ¿¶¼ÔÚ²»¶ÏÉÏÉý¡£½ü20¸öÔ£¬Ã¿¸öÔµĵçÁ¦ÐèÇóÔö³¤Âʶ¼ÔÚ10£¥ÒÔÉÏ£¬Õâ±íÃ÷µçÁ¦Êг¡Ä¿Ç°¼°Î´À´10ÄêÄÚ£¬½«´¦ÓÚ³ÖÐøµÄ¹©²»Ó¦ÇóµÄ״̬¡£È«¹ú·¶Î§ÄÚµÄȱµçÏÖÏó¸ø·¢µçºÍÊäµçϵͳ¶¼´øÀ´Á˼«´óµÄѹÁ¦£¬Í¬Ê±Ò²¶ÔµçÁ¦ÆóÒµÌá¸ßÉú²úЧÂÊ¡¢½µµÍÔËÓª³É±¾Ìá³öÁ˸ü¸ßµÄÒªÇó¡£
    ¿ÉϲµÄÊÇ£¬Ô½À´Ô½¶àµÄÆóÒµÒâʶµ½ÐÅÏ¢»¯½«ÓÐÖúÓÚ×Ô¼ºÊÊӦеĻ·¾³¡£ÊÂʵÉÏ£¬ÕýÊǵçÁ¦¸Ä¸ïºÍµç»ÄµÄ³öÏÖ£¬Ê¹·¢µçÆóÒµ¶ÔÐÅÏ¢»¯¼Ó´óÁËͶÈë¡£¾Ý¼ÆÊÀ×ÊѶ£¨CCW Research£©Ô¤¼Æ£¬2004ÄêµçÁ¦ÐÐÒµµÄIT²É¹º¹æÄ£½«´ïµ½59ÒÚÔªÈËÃñ±Ò£¬±È2003ÄêÔö³¤28%£¬Ôö·ù±È½Ï´ó£¬¸÷ÖÖÓ¦ÓÃϵͳ¿ªÊ¼µÃµ½ÖØÊÓ¡£µ«ÊÇ£¬ÖµµÃ×¢ÒâµÄÊÇ£¬µçÁ¦ÆóÒµÐÅÏ¢»¯ÈÔ´æÔÚÐí¶àؽ´ý½â¾öµÄÎÊÌâ¡£ÀýÈ磬ʹÓñê×¼Èí¼þ°üµÄÓ¦ÓÃϵͳ²»¶à£¬Ó¦ÓÃÈí¼þÖظ´¿ª·¢ÏÖÏóÈԱȽÏÑÏÖØ£»ÏµÍ³¼¯³É³Ì¶ÈµÍ£¬Êý¾Ý¹²ÏíµÄ²ã´Î¡¢·¶Î§Êܵ½¾ÖÏÞ£»Êý¾Ý²É¼¯µÄʱЧÐÔºÍ׼ȷÐÔ²»¹»£»ÐÅÏ¢»¯·¢Õ¹²»Æ½ºâ£»¶Ô´æÔÚÓÚϵͳÖдóÁ¿ÐÅÏ¢µÄ°²È«ÐÔÈÏʶ²»×ãµÈ¡£ÕâЩÎÊÌâµÄ´æÔÚʹµçÁ¦ÆóÒµµÄ·¢Õ¹Êܵ½ÁËÒ»¶¨³Ì¶ÈµÄÏÞÖÆ¡£
    Òª½â¾öÉÏÊöÎÊÌ⣬OracleÈÏΪ£¬·¢µçÆóÒµµÄÐÅÏ¢»¯¹¤×÷ÖصãÓ¦·ÅÔÚ“½¨ÉèÈí¼þϵͳƽ̨£¬ÕûºÏÏÖÓÐÐÅϢϵͳ£¬ÊµÏÖÆóÒµ×ÊÔ´ÓÅ»¯£¬Ì½Ë÷¿ªÕ¹µç×ÓÉÌÎñ”¡£Îª´Ë£¬OracleÌṩÁ˵çÁ¦ÐÐÒµ½â¾ö·½°¸¡£ÖµµÃÌá³öµÄÊÇ£¬ÓëÆäËûÈí¼þÌṩÉÌÏà±È£¬OracleµçÁ¦ÐÐÒµ½â¾ö·½°¸µÄ²»Í¬Ö®´¦ÔÚÓÚ£¬ËüÄܹ»´ÓÈ«·½Î»µÄ½Ç¶È£¬Ìṩ·¢µçÆóÒµËùÐèÒªµÄÕûÌå½â¾ö·½°¸¡£Ëü°´·¢µç¡¢Êäµç¡¢Åäµç¡¢ÊÛµçµÈÆóÒµµÄ¹©Ó¦Á´¹Øϵ£¬½«ÆóÒµ¼¨Ð§¹ÜÀíϵͳ¡¢ÆóÒµ×ÊÔ


Ïà¹ØÎĵµ£º

oracleÖÐtype

oracleÖÐ×Ô¶¨ÒåÊý¾ÝÀàÐÍ
oracleÖÐÓлù±¾µÄÊý¾ÝÀàÐÍ£¬Èçnumber£¬varchar2£¬date£¬numeric£¬float....µ«ÓÐʱºòÎÒÃÇÐèÒªÌØÊâµÄ¸ñʽ£¬È罫name¶¨ÒåΪ
£¨firstname,lastname£©µÄÐÎʽ£¬ÎÒÃÇÏë°ÑÕâ¸ö×÷Ϊһ¸ö±íµÄÒ»Áп´´ý£¬Õâʱºò¾Í²»ÒªÎÒÃÇ×Ô¼º¶¨ÒåÒ»¸öÊý¾ÝÀàÐÍ
create or replace type type_name as object(firstname varchar ......

OracleÁÙʱ±íµÄ¼¸ÖÖÓ÷¨¼°ÒâÒå

OracleÁÙʱ±í¿ÉÒÔ˵ÊÇÌá¸ßÊý¾Ý¿â´¦ÀíÐÔÄܵĺ÷½·¨£¬ÔÚûÓбØÒª´æ´¢Ê±£¬Ö»´æ´¢ÔÚOracleÁÙʱ±í¿Õ¼äÖС£Ï£Íû±¾ÎÄÄܶԴó¼ÒÓÐËù°ïÖú¡£
1 ¡¢Ç°ÑÔ
Ä¿Ç°ËùÓÐʹÓà Oracle ×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
µ±È»ÔÚ Oracle Öд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ« ......

Oracle ×Ö·û´®³¤¶Èº¯Êý


LENGTH calculates length using characters as defined by the input character set. 
LENGTHB uses bytes instead of characters. 
VSIZE returns the number of bytes in the internal representation of expr.
LENGTHC uses Unicode complete characters. 
LENGTH2 uses UCS2 codepoints. 
......

OracleÇ¿ÐжϿªÓû§Á¬½Ó


Ê×ÏȲéÕÒÄ¿±êÓû§µÄµ±Ç°½ø³Ì£º  
select sid,serial# from v$session where username='ERP';   
²éѯ½á¹û£º
sid serial#
222 123
122 233
Ç¿ÐжϿªÓû§Á¬½Ó£º  
alter system kill session 'sid,serial';   
ÀýÈ磺    
alter system kill session '222,123'; 
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ