ÎÒÃǹ«Ë¾ÓõÄOracle,µ«×ܳöÏÖ´æÖÐÎĵıêµã·ûºÅ·Ê±£¬ÔÚÊý¾Ý¿âÖлá±ä³ÉÂÒÂ룬¶øÆäËûµÄÖÐÎͼ¿ÉÒÔÕý³£´æ´¢£¬ÇëÎʸÃÈçºÎ½â¾ö°¡£¿ÕæÊÇÒ»µã°ì·¨¶¼Ã»ÓÐÁË£¬Ð»Ð»Ö¸µãselect chr(41380) from dual¿´¿´ÕâÑùÄÜÕý³£³ö·Õâ¸ö·ûºÅÂð ×Ö·û¼¯µÄÎÊÌâ°É Ëü´æµ½Êý¾Ý¿âÖоͱä³É£¿ºÅÁË£¬²»Ðа¡ select value from v$nls_parameters where parameter='NLS_CHARACTERSET' ¿´¿´ÄãÓõÄ×Ö·û¼¯ ZHS16CGB231280ÎÒÕâ¸ö²éѯ½á¹û²é³öÀ´µÄÊÇÎÒ±¾µØµÄ×Ö·û¼¯£¬»¹Êǹ«Ë¾·þÎñÆ÷ÉϵÄoracle×Ö·û¼¯°¡£¿ ORACLE·þÎñÆ÷¶ËµÄ µ±ORACLEÔÚ½øÐÐ×Ö·û¼¯Ö®¼äµÄת»»Ê± Èç¹ûÔÚÄ¿±ê×Ö·û¼¯ÖÐÕÒ²»µ½ÓëÔ´Ä¿±ê¼¯ÖÐÏà¹Ø·ûºÅÏàÓ¦µÄ×Ö·ûʱ ¾Í»áÖÃΪ? ×îºó»¹ÊÇͨ¹ý³ÌÐò¿ØÖƽâ¾öºÃ
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......
Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿ Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡ ¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡ which os ......