Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²ã´Î²éѯºÍ·ÖÎöº¯ÊýÔںŶÎѡȡÖеÄÓ¦ÓÃ
ÕªÒª
Ò»×éÁ¬ÐøµÄÊý£¬È¥µôÖмäһЩÊý£¬ÈçºÎÇó³öʣϵÄÊýµÄÇø¼ä£¨¼´ºÅ¶Î£©£¿ÖªµÀºÅ¶ÎµÄÆðÖ¹£¬ÈçºÎÇó³ö¸ÃºÅ¶ÎÄÚËùÓеÄÊý£¿ÖªµÀÒ»¸ö´óµÄºÅ¶Î·¶Î§ºÍÒѾ­È¡¹ýµÄºÅ¶Î£¬ÈçºÎÇó³ö¿ÉÓõĺŶΣ¿ÀûÓÃOracleÌṩµÄÇ¿´óµÄ²éѯ¹¦ÄÜÒÔ¼°·ÖÎöº¯Êý£¬ÎÒÃÇ¿ÉÒÔºÜÇáËɵĽâ¾öÉÏÊöÎÊÌâ¡£
¹Ø¼ü´Ê£º
......

javaµ÷ÓÃOracleÓû§µÇ¼´æ´¢¹ý³Ì

PROCEDURE user_Login (
      i_AuthID         IN       user_UserPass.UserID%TYPE,        --Óû§´úÂë
      i_FunctionCode   IN &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ