OracleµçÁ¦ÐÐÒµ½â¾ö·½°¸ ¸¶Ê×ê¿
ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾ÊÜ×ÅÇ°ËùδÓеÄѹÁ¦¡£
Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØиÄ×飬»®·ÖΪ¹ú¼ÒµçÍø¹«Ë¾ºÍÖйúÄÏ·½µçÍøÓÐÏÞ¹«Ë¾ÒÔ¼°Öйú»ªÄܼ¯ÍŹ«Ë¾¡¢Öйú´óÌƼ¯ÍŹ«Ë¾¡¢Öйú»ªµç¼¯ÍŹ«Ë¾¡¢Öйú¹úµç¼¯ÍŹ«Ë¾¡¢ÖйúµçÁ¦Í¶×ʼ¯ÍŹ«Ë¾µÈ5¼Ò·¢µç¹«Ë¾¡£ÖØ×éºóµÄÈô¸É·¢µç¼¯ÍÅ£¬ÈçºÎ½øÐм¯ÍÅ»¯¹ÜÀí£¿ÈçºÎ½«·ÖÉ¢µÄ£¬¸÷×ÔΪÕþµÄ·¢¡¢Êä¡¢Åä¡¢ËÍϵͳÓÐЧµØ½øÐÐÕûºÏ£¬Í³Ò»µØµ÷ÖÃ×ÊÔ´£¬¼ÓÇ¿È«Ãæ¼à¹Ü£¬Ìá¸ß×ۺϾºÕùÁ¦£¬³ÉΪ·¢µçÆóÒµËùÃæÁÙµÄ×îΪÑϾþµÄÌôÕ½¡£
ÁíÒ»·½Ã棬ÎÒ¹ú¸ßËÙ·¢Õ¹µÄ¹úÃñ¾¼Ã¶ÔµçÄÜÔ´³ÊÏÖ³öÁË“Ñ©±À”ʽµÄÐèÇó¡£½ü¼¸Äê¹úÄÚ¸÷ÐÐÒµ¶ÔµçÄÜÔ´µÄÐèÇóÁ¿¶¼ÔÚ²»¶ÏÉÏÉý¡£½ü20¸öÔ£¬Ã¿¸öÔµĵçÁ¦ÐèÇóÔö³¤Âʶ¼ÔÚ10£¥ÒÔÉÏ£¬Õâ±íÃ÷µçÁ¦Êг¡Ä¿Ç°¼°Î´À´10ÄêÄÚ£¬½«´¦ÓÚ³ÖÐøµÄ¹©²»Ó¦ÇóµÄ״̬¡£È«¹ú·¶Î§ÄÚµÄȱµçÏÖÏó¸ø·¢µçºÍÊäµçϵͳ¶¼´øÀ´Á˼«´óµÄѹÁ¦£¬Í¬Ê±Ò²¶ÔµçÁ¦ÆóÒµÌá¸ßÉú²úЧÂÊ¡¢½µµÍÔËÓª³É±¾Ìá³öÁ˸ü¸ßµÄÒªÇó¡£
¿ÉϲµÄÊÇ£¬Ô½À´Ô½¶àµÄÆóÒµÒâʶµ½ÐÅÏ¢»¯½«ÓÐÖúÓÚ×Ô¼ºÊÊӦеĻ·¾³¡£ÊÂʵÉÏ£¬ÕýÊǵçÁ¦¸Ä¸ïºÍµç»ÄµÄ³öÏÖ£¬Ê¹·¢µçÆóÒµ¶ÔÐÅÏ¢»¯¼Ó´óÁËͶÈë¡£¾Ý¼ÆÊÀ×ÊѶ£¨CCW Research£©Ô¤¼Æ£¬2004ÄêµçÁ¦ÐÐÒµµÄIT²É¹º¹æÄ£½«´ïµ½59ÒÚÔªÈËÃñ±Ò£¬±È2003ÄêÔö³¤28%£¬Ôö·ù±È½Ï´ó£¬¸÷ÖÖÓ¦ÓÃϵͳ¿ªÊ¼µÃµ½ÖØÊÓ¡£µ«ÊÇ£¬ÖµµÃ×¢ÒâµÄÊÇ£¬µçÁ¦ÆóÒµÐÅÏ¢»¯ÈÔ´æÔÚÐí¶àؽ´ý½â¾öµÄÎÊÌâ¡£ÀýÈ磬ʹÓñê×¼Èí¼þ°üµÄÓ¦ÓÃϵͳ²»¶à£¬Ó¦ÓÃÈí¼þÖظ´¿ª·¢ÏÖÏóÈԱȽÏÑÏÖØ£»ÏµÍ³¼¯³É³Ì¶ÈµÍ£¬Êý¾Ý¹²ÏíµÄ²ã´Î¡¢·¶Î§Êܵ½¾ÖÏÞ£»Êý¾Ý²É¼¯µÄʱЧÐÔºÍ׼ȷÐÔ²»¹»£»ÐÅÏ¢»¯·¢Õ¹²»Æ½ºâ£»¶Ô´æÔÚÓÚϵͳÖдóÁ¿ÐÅÏ¢µÄ°²È«ÐÔÈÏʶ²»×ãµÈ¡£ÕâЩÎÊÌâµÄ´æÔÚʹµçÁ¦ÆóÒµµÄ·¢Õ¹Êܵ½ÁËÒ»¶¨³Ì¶ÈµÄÏÞÖÆ¡£
Òª½â¾öÉÏÊöÎÊÌ⣬OracleÈÏΪ£¬·¢µçÆóÒµµÄÐÅÏ¢»¯¹¤×÷ÖصãÓ¦·ÅÔÚ“½¨ÉèÈí¼þϵͳƽ̨£¬ÕûºÏÏÖÓÐÐÅϢϵͳ£¬ÊµÏÖÆóÒµ×ÊÔ´ÓÅ»¯£¬Ì½Ë÷¿ªÕ¹µç×ÓÉÌÎñ”¡£Îª´Ë£¬OracleÌṩÁ˵çÁ¦ÐÐÒµ½â¾ö·½°¸¡£ÖµµÃÌá³öµÄÊÇ£¬ÓëÆäËûÈí¼þÌṩÉÌÏà±È£¬OracleµçÁ¦ÐÐÒµ½â¾ö·½°¸µÄ²»Í¬Ö®´¦ÔÚÓÚ£¬ËüÄܹ»´ÓÈ«·½Î»µÄ½Ç¶È£¬Ìṩ·¢µçÆóÒµËùÐèÒªµÄÕûÌå½â¾ö·½°¸¡£Ëü°´·¢µç¡¢Êäµç¡¢Åäµç¡¢ÊÛµçµÈÆóÒµµÄ¹©Ó¦Á´¹Øϵ£¬½«ÆóÒµ¼¨Ð§¹ÜÀíϵͳ¡¢ÆóÒµ×ÊÔ
Ïà¹ØÎĵµ£º
1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- ......
--sqlplus
sqlplus;
sys /password as sysdba;
--²éÕÒÓû§ID£¨user#£©,Êý¾Ý¿âÀïÃæ´æ·ÅµÄÓû§¶¼ÊÇ´óд!
select user#,name,password from user$ where name ='FACT';
USER# NAME   ......
Ê×ÏȲéÕÒÄ¿±êÓû§µÄµ±Ç°½ø³Ì£º
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';
......
Ò» Oracle¹«Ë¾¼ò½é
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆ临ÔӵĹØϵÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØϵÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......