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

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

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
   TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê                ÏÔʾֵ:07
        yyy three digits ÈýλÄê                ÏÔʾֵ:007
        yyyy four digits ËÄλÄê                ÏÔʾֵ:2007
           
        Month:     
        mm    number     Á½Î»Ô              ÏÔʾֵ:11
        mon    abbreviated ×Ö·û¼¯±íʾ          ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢ÎÄ°æ,ÏÔʾnov    
        month spelled out ×Ö·û¼¯±íʾ          ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢ÎÄ°æ,ÏÔʾnovember
         
        Day:     
        dd    number         µ±Ôµڼ¸Ìì        ÏÔʾֵ:02
        ddd    number         µ±ÄêµÚ¼¸Ìì        ÏÔʾֵ:02
        dy    abbreviated µ±Öܵڼ¸Ìì¼òÐ


Ïà¹ØÎĵµ£º

Oracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨

 
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2  ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç32

³ÉÔ±º¯ÊýºÍ¹ý³Ì
¹¹Ô캯Êý·½·¨
-oracleµÄÿ¸ö¶ÔÏó¾ùÓÐÒ»¸öÄÚÖõĹ¹Ô캯Êý·½·¨
-ÓÃÓÚ´´½¨¶ÔÏóµÄÒ»¸öʵÀý
-ÎÞÐèÏÔʽµØ¶¨Òå
-Óë¶ÔÏóÀàÐÍͬÃû
¶¨Òå¶ÔÏóÀàÐÍ
create or replace
type persontype as object
(
  id int,
  name varchar(20),
  member function ......

ʹÓÃ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£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ