Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Æô¶¯¹ý³Ì

Æô¶¯¸÷¸öģʽµÄ¹ý³Ì£º
1.nomount ----¶Á²ÎÊýÎļþ---À©ÄÚ´æ/Æô½ø³Ì£¨Ö÷ÒªÊÇÖØ½¨¿ØÖÆÎļþ£©
2.mount ------¶Á²ÎÊýÎļþ---ÕÒ¿ØÖÆÎļþ---¿ª¿ØÖÆÎļþ---ÕÒÊý¾ÝÎļþ/ÈÕÖ¾ÎļþλÖÃÓëÃû³Æ---ÁªÏµÊµÀýÓëÊý¾Ý¿â
  £¨Ö÷ÒªÊǻָ´Êý¾Ý¿â£©
3.open--------´ò¿ªÊý¾ÝÎļþ---´ò¿ªÈÕÖ¾Îļþ ......

ʹÓÃoracleµÄjavaJVM£¬trigger

create or replace java source named FirstClass as
public class FirstClass{
public static String greeting(String name){
return "Hello " + name + "!";
}
}
/
create or replace function firstclass_greeting (name varchar2) ret ......

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

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

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......

ORACLEº¯Êý´óÈ«

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