ORACLEÊý¾Ý¿âÖйØÓÚÓαêºÍ¼Ç¼±íµÄËٶȲâÊÔ
1
¡¢ÎÊÌâÌá³ö
ÔÚÎÒÃÇÈÕ³£µÄÊý¾Ý¿â²Ù×÷ÓÈÆäÊÇ´æ´¢¹ý³ÌÉè¼ÆÖУ¬¾³£ÓмǼ±íÖ®ÀàµÄ¼¯ºÏ¡¢ÏÔʾÓαêµÈ²Ù×÷£¬µ«ÕâÁ½ÖÖÊý¾Ý´¦Àí·½Ê½ÔÚËٶȼ°ÐÔÄÜÉÏÓÐʲôÇø±ðÄØ£¿
2
¡¢²âÊÔ·½·¨
ÔÚ
ORACLE
Êý¾Ý¿âÖд´½¨Ò»¸öÊý¾Ý±í£¬È»ºó¶Ô´´½¨µÄÊý¾Ý±í·Ö±ð²åÈë
100
Ìõ¡¢
1000
Ìõ¡¢
10000
Ìõ¡¢
100000
ÌõÊý¾Ý£¬×îºó¶ÔÕâЩÊý¾Ý·Ö±ðÓÃÓαêºÍ¼Ç¼±íÖ´ÐÐÏàͬ¹¦ÄܵIJÙ×÷
10
´Î£¬¼ÆËãƽ¾ùÏûºÄµÄϵͳʱ¼ä¡£
£¨
1
£©´´½¨Êý¾Ý±í
create table table_test
(
COL1 INTEGER,
COL2 VARCHAR2(20)
)
£¨
2
£©²åÈëÊý¾Ý£¨ÒÔ
100000
ÌõÊý¾ÝΪÀý£©
--
Ñ»·
100000
´ÎÌí¼Ó
DECLARE
i INTEGER;
BEGIN
FOR i IN 1..100000 LOOP
INSERT INTO TABLE_TEST(COL1,COL2)
VALUES(i,'ADD'||i);
END LOOP;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
£¨
3
£©Óαê²Ù×÷
--
Óα괦Àí
DECLARE
v_COL1 TABLE_TEST.COL1%TYPE;
v_COL2 TABLE_TEST.COL2%TYPE;
v_BEGIN INTEGER;
v_END INTEGER;
CURSOR CUR_TYPE IS
SELECT COL1,COL2 from TABLE_TEST;
BEGIN
SELECT DBMS_UTILITY.get_time INTO v_BEGIN
from DUAL;
DBMS_OUTPUT.put_line('
¿ªÊ¼Ê±¼ä£º
'||v_BEGIN);
IF CUR_TYPE%ISOPEN = FALSE then
OPEN CUR_TYPE;
END IF;
FETCH CUR_TYPE INTO v_COL1,v_COL2;
WHILE CUR_TYPE%FOUND
LOOP
FETCH CUR_TYPE INTO v_COL1,v_COL2;
END LOOP;
CLOSE CUR_TYPE;
SELECT DBMS_UTILITY.get_time INTO v_END
from DUAL;
DBMS_OUTPUT.put_line('
½áÊøʱ¼ä£º
'||v_END);
DBMS_OUTPUT.put_line('
¿ªÊ¼Ê±¼ä
'||v_BEGIN||'
£¬½áÊøʱ¼ä
'||v_END||'
ÏûºÄʱ¼ä
'||TO_CHAR(v_END-v_BEGIN));
DBMS_OUTPUT.put_line('
ÏûºÄʱ¼ä£º
'||TO_CHAR(v_END-v_BEGIN));
END;
£¨
4
£©¼Ç¼±í²Ù×÷
--
¼Ç¼±í´¦Àí
DECLARE
v_COL1 
Ïà¹ØÎĵµ£º
¾¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´ÎÖØ×°£¬ORACLEÖØ×°N´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 Ï°²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹Ø˵ ......
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃ漸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨. ......
oracle½«×Ö·û´®×ª»»Îª12СʱÓë24СʱÖÆ£º
--12СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-m ......
ÎÒ½ñÌìѧϰÁËOracle Êý¾Ý¿âµÄÅäÖü°¹ÜÀí£º
1 Oracle Êý¾Ý¿âÌåϵ½á¹¹¼ò½é
1.1 ƽ³£Ëù˵µÄ Oracle »ò Oracle Êý¾Ý¿âÖ¸µÄÊÇ Oracle Êý¾Ý¿â¹ÜÀíϵͳ. Oracle Êý¾Ý¿â¹ÜÀíϵͳÊǹÜÀíÊý¾Ý¿â·ÃÎʵļÆËã»úÈí¼ ......
¡¡¡¡´óѧµÄʱºò£¬ÎÒÊǹÜÀíѧԺµÄ£¬ºóÀ´Ï¸·ÖרҵµÄʱºòÑ¡ÔñÁËÐÅÏ¢¹ÜÀí¡£ÓÚÊǹÜÀí¡¢»á¼Æ¡¢²ÆÎñ¡¢»úе¡¢µç×Ó£¬ÉõÖÁ˵Ç鱨¼ìË÷¶¼Ñ§¹ý£¬µ±È»Ò²°üÀ¨¼ÆËã»ú¡£
¡¡¡¡Èç¹û²»ËãfoxbaseºÍfoxproµÄ»°£¬Êý¾Ý¿â·½Ãæ½ö½öѧ¹ýÒ»ÃÅÊý¾Ý¿âÔÀí£¬ÓõĽ̲ÄÊÇStanfordµÄÓ°Ó¡°æ¡£
¡¡¡¡µ±Ê±ÓÐÒ»¸öΤÀÏʦ£¬×ÜÊÇ´µËýÀϹ«ÊÇMITµÄ²©Ê¿£¬ºÜNB¡£×ÜÊÇ¶Ô ......