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

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


Ïà¹ØÎĵµ£º

oracle ±Ê¼Ç III Ö®´æ´¢¹ý³ÌÓ뺯Êý

DML(Manipulation):Êý¾Ý²Ù×÷ÓïÑÔ
CRUD
DDL(Definition): Êý¾Ý¶¨ÒåÓïÑÔ,Óë±í£¬Ë÷Òý£¬Í¬Òå´ÊÓйØ
create,alter,drop,rename,truncate(Çå¿Õ)
DCL(Control): Êý¾Ý¿ØÖÆÓïÑÔ£¬ÓëȨÏÞÓйØ
grant,revoke
TCL(Transaction Control): ÊÂÎñ¿ØÖÆÓïÑÔ,ÓëÊÂÎñÓйØ
commit,rollback,savepoint
==========================
´æ´¢ ......

ÔÚRedhat 5 Éϰ²×°Oracle 10g

     ³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
      ±¾ÎÄÖØµãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......

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 
¸ø³öÕ ......

oracleµÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELO ......

Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ

OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ