Çë½ÌÒ»¸öoracle±¸·ÝµÄÎÊÌâ - Oracle / ¿ª·¢
ÏëÔÚunix»·¾³ÏÂд¸öshell£¬
¶¨ÆÚ±¸·ÝÒ»¸ö±ítest ÖеÄpartition£¬partiton¡¡ÒÔP+ÈÕÆÚÃüÃû£¬ÀýÈçP20100426
ÏÖÔÚÏ뱸·ÝÉϸöÔ±ítestÖеÄpartition¸ÃÈçºÎ×öÄØ£¿
ÓÉÓÚϵͳ²»Ö§³Ö¡¡date -d ·½·¨£¬ËùÒÔÓÃexp¡¡·½·¨Ê±£¬²»ÖªµÀ¸ÃÈçºÎÈ¡ÉϸöÔµÄpartitonÃû×ÖÁË£¿
Çë½Ì¸÷λÊÇ·ñ»¹ÓÐÆäËû·½·¨¿ÉÒÔʵÏÖ£¿
ÄãµÄϵͳ֧³Ö
date +"%Y%m"
Õâ¸ö²»£¿
Õâ¸öÖ§³Ö
date '+%y-%m-%d'
Õâ¸öÊǵ±ÌìµÄ
ÎÊÌâÊÇ¡¡ÒªÈçºÎÈ¡¡¡ÉϸöÔµÄ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......