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

oracleµÄһЩ֪ʶС½á

SqlÖÐÁ½¸ö“-”±íʾעÊ͵ĿªÊ¼¡£
Æ´½ÓÔËËã·û£º”||”,×¢Ò⣺ֻÓÐÔÚËùÓеÄÔËËã·ûΪnullʱ£¬Æ´½ÓµÄ½á¹ûÊÇnull¡£
±È½ÏÔËËã·ûÓÃÓڱȽÏÁ½¸öÖµ»ò±í´ïʽ£¬¸ø³öÒ»¸ö²¼¶ûÐ͵Ľá¹û true,false,null.
±È½ÏÔËËã·û£º
=
!=  <>   ^=
[not]in °üº¬
Any some ½«Ò»¸öÖµÓëÁбíÖеÄÿ¸öÖµ»òÕßÓë²éѯ½á¹ûÖеÄÿһ¸öÖµ½øÐбȽϣ¬¼ÙÈç²éѯûÓзµ»Ø½á¹û£¬Ôò½á¹ûΪfalse¡£Ç°Ãæ±ØÐëÓÐ=,!=,>=,<µÈ·ûºÅ¡£
Select last_name from emp where salary<=any(select salary from emp where deptno=10);
 
All ½«Ò»¸öÖµÓëÁбíÖеÄÿ¸öÖµ»òÕßÓë²éѯ½á¹ûÖеÄÿ¸öÖµ½øÐбȽϣ¬¼ÙÈç²éѯûÓзµ»Ø½á¹û£¬Ôò½á¹ûΪtrue¡£Ç°Ãæ±ØÐëÓÐ=,!=,<,>µÈ·ûºÅ¡£
Select last_name from emp where salary<=all(500,1000.9000);
 
[not] between a and b
Select last_name from emp where salary between 4000 and 10000;
 
[not] exists ¼ÙÈçÒ»¸ö×Ó²éѯÖÁÉÙ·µ»ØÒ»ÐÐʱ£¬½á¹ûΪtrue
Select last_name from emp a where not exists(select ‘x’ dummu from emp b where b.deptno=10 and a.last_name=b.last_name);
 
A [not] like b [escape ‘char’] ÓÃÓÚģʽƥÅ䣻¼ÙÈçģʽaÓëģʽbÆ¥Å䣬Ôò½á¹ûΪtrue¡£Ä£Ê½Æ¥Åä·û%ÓÃÓÚÆ¥Åä0¸ö»òÈÎÒâ¶à¸ö×Ö·û¡£_ÓÃÓÚÆ¥ÅäÒ»¸ö×Ö·û¡£¹Ø¼ü×ÖescapeÓÃÓÚÌáʾoracle½âÊÍ%ºÍ_×Ö·û£¬²»Òª½«ËûÃÇ×÷ÎªÌØÊâ×Ö·û´®´¦Àí¡£
Select last_name from emp where last_name not like ‘Th%’;
Select last_name from emp where last_name like ‘_tt%’;
Select synonym_name from dba_synonums wnere synonym_name like ‘all\_u%’escape’\’;
 
Is [not] null Ö»ÓÐÒ»¸öÔËËã·û£¬ÓÃÀ´²âÊÔÆäÖµÊÇ·ñΪ¿Õ¡£
Select last_name from emp where salary is not null;
 
Âß¼­ÔËËã·û£º
Not ½«½á¹ûÈ¡·´¡£¼ÙÈçÔËËãÊýÊÇnull£¬Ôò·µ»Ønull£¬µ±ÔËËãÊýÊÇfalseʱ£¬½á¹û·µ»Øtrue£¬·ñÔò·µ»Øfalse¡£
Select * from emp where not (salary<100)
And ¼ÙÈçËùÓеÄÔËËãÊýΪtrue£¬Ôò½á¹ûΪtrue£»Èç¹ûÆäÖÐÒ»¸öΪfalse£¬Ôò½á¹ûΪfalse¡£·ñÔò½á¹ûÊÇnull¡£
Or¼ÙÈçËùÓеÄÔËËãÊýΪfalse£¬Ôò½á¹ûΪfalse£»Èç¹ûÆäÖÐÒ»¸öΪtrue£¬Ôò½á¹ûΪtrue¡£·ñÔò½á¹ûÊÇnull¡£
 
¼¯ºÏÔËËã·û£º
Union ·µ»ØËùÓвéѯ½á¹ûÖеÄÐУ¬²»°üÀ¨Öظ´µÄÖµ


Ïà¹ØÎĵµ£º

ORACLE PL/SQL ´æ´¢¹ý³Ì½Ì³Ì


(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà  ÕâÑù£º     
SELECT tmp#_seq.NEXTVAL
        INTO id_temp
        from DUAL;  È»ºó¿ÉÒ ......

OracleÖеÄcovering index

 CSDNÀïµÄÒ»¸öÅóÓÑÎʵ½ÁËÕâ¸öË÷Òý¸²¸ÇµÄ¸ÅÄî¡£ Õâ¸ö¸ÅÄîºÜСµÄ֪ʶµã£¬ÔÚÎÒµÄÂÛ̳ÀïÓнâÊÍ“”£¬²»¹ý×÷ΪOracle°æÖ÷£¬²»ÄÜÔÚ»ØÌûÀï¼ÓÉÏÍøÍâµÄµØÖ·Á´½Ó£¬ËùÒÔÕâÀïÔÚCSDNÀïÌûÉÏÒ»·Ý
±ÈÈçÓи´ºÏË÷ÒýΪ3¸ö×ֶΣºf1 + f2 + f3,ÇëÎÊ: 
1: select f1, f2, f3, f4 from table where f1 = 'XX' and f2 = 'XX'. ......

Oracle³£ÓÃɵ¹ÏÎÊÌâ1000ÎÊ


   
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ.
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager ......

OracleÈÕ³£Î¬»¤µãµÎ

OracleάÈÕ³£»¤µãµÎ
    ËäÈ»Oracleά»¤²»ÊÇÎÒµÄÖ°Ô𣬵«Æ½Ê±»¹ÊÇÄÑÃâÒª¸úËü´ò½»µÀ£¬Òò´Ë¶ÔÓÚOracleµÄÈÕ³£Î¬»¤ÂÔÖªÒ»¶þ»¹ÊǺÜÓкô¦µÄ¡£
 1. µÇ¼£º
  £¨1£©²ÉÓÃϵͳ¹ÜÀíÔ±Óû§µÇ¼£º
#su - oracle
$ sqlplus / as sysdba
  £¨2£©²ÉÓÃÒ»°ãÓû§µÇ¼£¬¼ÙÉèÓû§ÃûΪoracle£¬ÃÜÂëΪpasswor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ