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 µ±Öܵڼ¸Ìì¼òÐ
Ïà¹ØÎĵµ£º
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......
³ÉÔ±º¯ÊýºÍ¹ý³Ì
¹¹Ô캯Êý·½·¨
-oracleµÄÿ¸ö¶ÔÏó¾ùÓÐÒ»¸öÄÚÖõĹ¹Ô캯Êý·½·¨
-ÓÃÓÚ´´½¨¶ÔÏóµÄÒ»¸öʵÀý
-ÎÞÐèÏÔʽµØ¶¨Òå
-Óë¶ÔÏóÀàÐÍͬÃû
¶¨Òå¶ÔÏóÀàÐÍ
create or replace
type persontype as object
(
id int,
name varchar(20),
member function ......
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µÄһЩ×ܽᣨԣ© ÊÕ²Ø
http://blog.chinaunix.net/u/25176/showart_2036107.html
Êý¾Ý²Ö¿âÖеÄETLÏêϸµÄ·ÖΪËĸö½×¶Î£ºÌáÈ¡£¬´«Ê䣬ת»»£¬×°ÔØ¡£ÎÒÏȼòµ¥µÄ½éÉÜÒ»ÏÂÌáÈ¡ºÍ´«ÊäµÄ·ÖÀàºÍ·½·¨£º
Ò»£ºÌáÈ¡
ÌáÈ¡¿ÉÒÔ·ÖΪÂß¼ÌáÈ¡£¬ºÍÎïÀíÌáÈ¡¡£
1£ºÂß¼ÌáÈ¡°´ÕÕ¹æÄ£·ÖΪ£ºÍ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......