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

Oracle ϵͳ³£¼û´íÎó


p580  ÎÄÆ½
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
    ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000Äêǰºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøÒ³Ç¶ÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡£µ±Ç°Öмä¼þ¼¼ÊõÄ£ÐÍÒѾ­³ÉÊ죬Öмä¼þϵͳ°üº¬×ŶÔÊý¾Ý¿âÁ¬½Ó³ØµÄÖ§³Ö¡£ÍøÒ³Á¬½ÓÔì³ÉµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª²Ù×÷ÒѾ­ºÜÉÙ¼ûÁË¡£
   ÔÚ¿Í»§/·þÎñÆ÷½á¹¹µÄÓ¦ÓÃÖУ¬Ó¦Óô°¿Ú½çÃæÉÏÒ²²»½¨Òé·ÅÖÃÊý¾Ý¿âÁ¬½Ó½Å±¾£¬¶øÊÇÔÚÓ¦ÓÃÆô¶¯ÆÚ¼äÖ®¼äÁ¬½ÓÊý¾Ý¿â¼´¿É¡£
³£¼ûÎÊÌâ¶þ£ºSQL²»ÄÜÖØÓú͹²Ïí³ØµÍЧ
   ÔÚSQL¿ª·¢Öв»×¢ÒâÓï·¨¼°²éѯ½á¹¹µÄÒ»Ö±£¬½«µ¼ÖÂSQLÔÚÖ´Ðйý³ÌÖб»²»¶ÏµØ½âÎö£¬ºÄ·Ñϵͳ×ÊÔ´¡£ÀýÈ磬²éѯÌõ¼þÖÐÖ±½ÓÒýÓÃÊýÖµ£¬¶ø·Ç°ó¶¨±äÁ¿¡£ÕâÔÚÔËÐл·¾³Ï½«Òâζ×Ų»Í¬µÄSQL¡£ËäÈ»Æäº¬ÒåÒ»Ö£¬µ«OracleÈÔÈ»»á½«Æä½âÎöΪ²»Í¬µÄSQL¡£Oracle½¨ÒéʹÓð󶨱äÁ¿µÄ·½·¨½øÐÐÓαêµÄÖØÓá£
³£¼ûÎÊÌâÈý£º²»Á¼SQLÓï¾ä
   ²»Á¼SQLÊÇÖ¸ÄÇЩºÄ·ÑÁË´óÁ¿Ê±¼ä¡¢´óÁ¿ÏµÍ³×ÊÔ´µÄSQLÓï¾ä¡£ÀýÈçÔËÐÐʱ¼ä³¬¹ý9СʱµÄ±¨±í»òÕßÊÇÒ»¸öºÄʱ3·ÖÖÓµÄÁª»ú²éѯ¡£ÕâЩ“ºÄ·Ñ¾Þ´ó”µÄSQLÈç¹ûÄܵõ½ÓÐЧµ÷Õû£¬ÆäÓÅ»¯¹±Ï×ÂʱØÈ»¿ÉȦ¿Éµã¡£Oracle 10gR2ÖÐADDM(×Ô¶¯Êý¾Ý¿âÕï¶Ï¼àÊÓÆ÷£©¿ÉÒÔÓÃÀ´Ê¶±ð¸ßÏûºÄSQL£¬ÒÔ¼°Ê¹ÓÃSQL¹ËÎʹ¤¾ß½øÐÐÓÅ»¯¡£
³£¼ûÎÊÌâËÄ:ʹÓӷdz£Óõijõʼ»¯²ÎÊý”
   Õâ¿ÉÄÜÊÇ×î³£¼ûµÄ´íÎóÁË£ºÓû§Ê¹ÓÃÁË´óÁ¿×Ô¶¨Òå²ÎÊý£¬²¢ÆÚÍûij¸ö“ÉñÃØ”²ÎÊý»á¸øÏµÍ³´øÀ´ÖʵķÉÔ¾¡£Õâ¸öÎóÇøÀ´Ô´ÓÚÓû§¶ÔOracleÊý¾Ý¿âϵͳ²ÎÊýµÄ²»Àí½â¡£Êµ¼ÊÉÏÎÒÃÇÓ¦¸ÃÏàÐÅÕâÑùÒ»µã£ºÄ¬Èϰ²×°µÄÊý¾Ý¿âÍùÍùÊÊÓ¦ÓÚ´ó¶àÊýÓ¦ÓÃÇé¿ö£¬ÆäÅäÖÿÉÄܾÍÊÇ×îºÃµÄ¡£
³£¼ûÎÊÌâÎ壺Êý¾Ý¿âI/O²»¾ùºâ
Êý¾Ý¿âÔÚAIX½øÐÐÎïÀíʵʩʱ£¬Ôڹ滮Êý¾Ý´æ´¢·½ÃæÓ¦¿¼ÂÇÊý¾Ý´æ·Å¾ùºâ¼°I/O¾ùºâÎÊÌâ¡£Ö¸µ¼Ô­ÔòÊÇI/O²Ù×÷ÔÚ´æ´¢×Óϵͳ´ø¿íÉϵľùºâ¡£ºÜ¶àϵͳ°´ÕÕ´ÅÅÌ»òÕß´æ´¢Âß¼­µ¥Ôª£¨LUN£©´æ´¢Êý¾Ý£¬¶ø²¢·Ç´ø¿íµÄ¾ùºâ£¬Òò´ËÕû¸ö´æ´¢×Óϵͳ²»ÄÜÐγÉI/O¾ùºâ£¬µ¼ÖÂϵͳI/O»ºÂý¡£
³£¼ûÎÊÌâÁù£ºÖØ×öÈÕÖ¾ÉèÖÃÎÊÌâ
Êý¾Ý¿âµÄÈÕÖ¾²»ÄÜ̫С£¬Ò²²»ÄÜÌ«ÉÙ£¬·ñÔòСµÄÖØ×öÈÕÖ¾»áÔì³Éϵͳ¼ì²éµãƵ·±²úÉú£¬¶ÔÊý¾Ý»º´æºÍ´æ´¢×ÓϵͳÔì³ÉI/OѹÁ¦¡£Èç¹ûÖØ×öÈÕÖ¾×é½ÏÉÙ£¬ÔòÓпÉÄÜÐγÉÒò¹éµµÎÊÌâµ¼ÖµÄÈÕÖ¾Çл»µÈ´ý¡£
³£¼ûÎÊÌâÆß£º´ó±íµÄÈ«±íɨÃè
´ï±êµÄÈ«±íɨÃ


Ïà¹ØÎĵµ£º

ORACLEº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
        A         A      ZERO     ......

OracleÅäÖñ¾µØNet·þÎñÃû

Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Co ......

ORACLEµ¼Èëµ¼³öÃüÁî½âÎö

±¾ÎĶÔOracleÊý¾ÝµÄµ¼Èëµ¼³ö imp ,exp Á½¸öÃüÁî½øÐÐÁ˽éÉÜ, ²¢¶ÔÆäÏàÓ¦µÄ²ÎÊý½øÐÐÁË˵Ã÷,È»ºóͨ¹ýһЩʾÀý½øÐÐÑÝÁ·,¼ÓÉîÀí½â.
ÎÄÕÂ×îºó¶ÔÔËÓÃÕâÁ½¸öÃüÁî¿ÉÄܳöÏÖµÄÎÊÌâ(ÈçȨÏÞ²»¹»,²»Í¬oracle°æ±¾)½øÐÐÁË̽ÌÖ,²¢Ìá³öÁËÏàÓ¦µÄ½â¾ö·½°¸;
±¾ÎIJ¿·ÖÄÚÈÝժ¼×ÔÍøÂç,¸ÐÐ»ÍøÓѵľ­Ñé×ܽá;
Ò».˵Ã÷
   oracle µÄexp/i ......

oracle³éÈ¡º¯Êý extract()

auhtor£ºskate
time£º2010/03/03
oracle³éÈ¡º¯Êý
½ñÌìÅóÓÑÎʸöÎÊÌ⣬ÈçºÎ³éȡʱ¼äµÄ“Сʱ”
oracleµÄ³éÈ¡º¯ÊýÊÇ extrac()Óï·¨:
SELECT EXTRACT(YEAR from SYSDATE) from DUAL; return Current Year
SELECT EXTRACT(MONTH from SYSDATE) from DUAL; return Current Month
SELECT EXTRACT(DAY from SYSDA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ