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

Oracle All And Any

ת£ºOracle All And Any
    ÕâÊÇÔÚOracleÖбȽÏÈÝÒ×±»ºöÊÓµÄÁ½¸öÌõ¼þº¯Êý£¬µ«ÕâÁ½¸öº¯ÊýÆäʵ¶Ô¼ò»¯SqlÓï¾äÊǷdz£ÖØÒªµÄ×÷Óõġ£
¡¡¡¡ÀýÈç
scott@eddev> select ename, sal  from emp  where sal > any (1600, 2999);
ENAME             SAL
---------- ----------
JONES            2975
BLAKE            2850
CLARK            2450
SCOTT            3000
KING             5000
FORD             3000
6 rows selected.
ʵ¼ÊÉÏÒÔÉÏÓï¾ä¿ÉÒÔµÈÓÚ£º
select ename, sal  from emp where sal > 1600 or sal > 2999;
ËùÒÔAnyÊǵÈÓÚN¸öorÓï¾ä¡£
ÓÖÈç
select ename from emp  where substr(ename,1,1) = any ('A', 'W', 'J');
µÈͬÓÚ£º
select ename from emp  where substr(ename,1,1) = 'A' or substr(ename,1,1) ='W' or substr(ename,1,1) ='J';
ÁíÍâ
scott@eddev> select ename, sal   from emp   where sal > all (1600, 2999);
ENAME             SAL
---------- ----------
SCOTT            3000
KING             5000
FORD             3000
ʵ¼ÊÉÏÒÔÉÏÓï¾ä¿ÉÒÔµÈÓÚ£º
select ename, sal   from emp   where sal > 1600 and sal > 2999;
ËùÒÔAllÊǵÈÓÚN¸öAndÓï¾ä¡£


Ïà¹ØÎĵµ£º

ÎÒ¶ÔORACLE BI µÄETLµÄһЩ×ܽá

ÎÒ¶ÔORACLE BI µÄETLµÄһЩ×ܽᣨԭ£© ÊÕ²Ø
http://blog.chinaunix.net/u/25176/showart_2036107.html
Êý¾Ý²Ö¿âÖеÄETLÏêϸµÄ·ÖΪËĸö½×¶Î£ºÌáÈ¡£¬´«Ê䣬ת»»£¬×°ÔØ¡£ÎÒÏȼòµ¥µÄ½éÉÜÒ»ÏÂÌáÈ¡ºÍ´«ÊäµÄ·ÖÀàºÍ·½·¨£º
Ò»£ºÌáÈ¡
   ÌáÈ¡¿ÉÒÔ·ÖΪÂß¼­ÌáÈ¡£¬ºÍÎïÀíÌáÈ¡¡£
   1£ºÂß¼­ÌáÈ¡°´ÕÕ¹æÄ£·ÖΪ£ºÍ ......

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
   TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê       &nb ......

OracleÉó¼Æ¹¦ÄÜ


OracleÉó¼Æ¹¦ÄÜ
Éó¼ÆÊǶÔÑ¡¶¨µÄÓû§¶¯×÷µÄ¼à¿ØºÍ¼Ç¼£¬Í¨³£ÓÃÓÚ£º
u          Éó²é¿ÉÒɵĻ¡£ÀýÈ磺Êý¾Ý±»·ÇÊÚȨÓû§Ëùɾ³ý£¬´Ëʱ°²È«¹ÜÀíÔ±¿É¾ö¶¨¶Ô¸Ã Êý¾Ý¿âµÄËùÓÐÁ¬½Ó½øÐÐÉó¼Æ£¬ÒÔ¼°¶ÔÊý¾Ý¿âµÄËùÓбíµÄ³É¹¦µØ»ò²»³É¹¦µØɾ³ý½øÐÐÉó¼Æ¡£
u    &n ......

db2,oracle,mysql³£ÓÃÃüÁî±È½Ï


¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËƵãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØѧ»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊ×ƪ£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......

ORACLEº¯Êý´óÈ«

LONEFOXÌâ¼Ç£º
×î½ü¸ãORACLE£¬ ת¹ýÀ´¹©²Î¿¼¡£
=================================
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û
 ÓÃ;
 Àý×Ó
 
+ -
 ±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿ÉÊ¡È¥ +
 -1234.56
 
+
 ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó
 A=c+b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ