OracleÖеÄNullÖµ½âÎö
ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓкÍNullÏà¹ØµÄ²Ù×÷µÄ½á¹û¶¼¿ÉÒÔ´ÓNullµÄ¸ÅÄîÍƵ¼³öÀ´¡£
ÅжÏÒ»¸ö×Ö¶ÎÊÇ·ñΪNull£¬ Ó¦¸ÃÓÃIS Null»òIS NOT Null£¬¶ø²»ÄÜÓÑ=’¡£¶ÔNullµÄÅжÏÖ»Äܶ¨ÐÔ£¬¼ÈÊDz»ÊÇNull£¨IS Null/IS NOT Null£©£¬¶ø²»Äܶ¨Öµ¡£¼òµ¥µÄ˵£¬ÓÉÓÚNull´æÔÚ×ÅÎÞÊýµÄ¿ÉÄÜ£¬Òò´ËÁ½¸öNull²»ÊÇÏàµÈµÄ¹Øϵ£¬Í¬ÑùÒ²²»ÄÜ˵Á½¸öNull¾Í²»ÏàµÈ£¬»òÕ߱ȽÏÁ½¸ö NullµÄ´óС£¬ÕâЩ²Ù×÷¶¼ÊÇûÓÐÒâÒ壬µÃ²»µ½Ò»¸öÈ·ÇеĴ𰸵ġ£Òò´Ë£¬¶ÔNullµÄ=¡¢!=¡¢>¡¢<¡¢>=¡¢<=µÈ²Ù×÷µÄ½á¹û ¶¼ÊÇδ֪µÄ£¬Ò²¾ÍËã˵£¬ÕâЩ²Ù×÷µÄ½á¹ûÈÔÈ»ÊÇNull¡£
ͬÀí£¬¶ÔNull½øÐÐ+¡¢-¡¢*¡¢/µÈ²Ù×÷µÄ½á¹ûÒ²ÊÇδ֪µÄ£¬ËùÒÔÒ²ÊÇNull¡£
ËùÒÔ£¬ºÜ¶àʱºò»áÕâÑù×ܽáNull£¬³ýÁËIS Null¡¢IS NOT NullÒÔÍ⣬¶ÔNullµÄÈκβÙ×÷µÄ½á¹û»¹ÊÇNull¡£
Oracle ÖеÄNullÖµºÍSQL Server ÖеIJ¶à£¬µ«ÊÇÓиöÃ÷ÏÔµÄÇø±ð£¬ÔÚOracleÖпÕ×Ö·û´®(‘’)±»ÊÓ×÷NullÖµ¡£ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪNull£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1. Ö÷¼ü×ֶΣ¨primary key£©;
2. ¶¨ÒåʱÒѾ¼ÓÁËNOT NullÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵ÁËÕâô¶à£¬ÎÒÃÇÀ´¿´Ò»Ð©Àý×Ó¡£
1. Null ±È½Ï
SQL> select 1 from dual where Null=Null;
-------------------------------------------------------------------------------
ûÓв鵽¼Ç¼
SQL> select 1 from dual where Null='';
-------------------------------------------------------------------------------
ûÓв鵽¼Ç¼
SQL>select 1 from dual where ''='';
-------------------------------------------------------------------------------
ûÓв鵽¼Ç¼
SQL> select 1 from dual where Null is Null;
-------------------------------------------------------------------------------
1
SQL>se
Ïà¹ØÎĵµ£º
Union£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Union All£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬°üÀ¨Öظ´ÐУ¬²»½øÐÐÅÅÐò£»
Intersect£¬¶ÔÁ½¸ö½á¹û¼¯½øÐн»¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Minus£¬¶ÔÁ½¸ö½á¹û¼¯½øÐвî²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò¡£
¿ÉÒÔÔÚ×î ......
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
¸ø³öÕ ......
´Ó10g¿ªÊ¼£¬oracle¿ªÊ¼ÌṩShrinkµÄÃüÁ¼ÙÈçÎÒÃǵıí¿Õ¼äÖÐÖ§³Ö×Ô¶¯¶Î¿Õ¼ä¹ÜÀí (ASSM),¾Í¿ÉÒÔʹÓÃÕâ¸öÌØÐÔËõС¶Î£¬¼´½µµÍHWM¡£ÕâÀïÐèҪǿµ÷Ò»µã£¬10gµÄÕâ¸öÐÂÌØÐÔ£¬½ö¶ÔASSM±í¿Õ¼äÓÐЧ£¬·ñÔò»á±¨ ORA-10635: Invalid segment or tablespace type¡£
Èç¹û¾³£ÔÚ±íÉÏÖ´ÐÐDML²Ù× ......
SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......