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

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 


Ïà¹ØÎĵµ£º

OracleÓÅ»¯Æ÷µÄÓÅ»¯·½Ê½ºÍÓÅ»¯Ä£Ê½

OracleÔÚÖ´ÐÐÒ»¸öSQL֮ǰ,Ê×ÏÈÒª·ÖÎöÒ»ÏÂÓï¾äµÄÖ´Ðмƻ®,È»ºóÔÙ°´Ö´Ðмƻ®È¥Ö´ÐС£·ÖÎöÓï¾äµÄÖ´Ðмƻ®µÄ¹¤×÷ÊÇÓÉÓÅ»¯Æ÷(Optimizer)À´Íê³ÉµÄ¡£²»Í¬µÄÇé¿ö,Ò»ÌõSQL¿ÉÄÜÓжàÖÖÖ´Ðмƻ®,µ«ÔÚijһʱµã,Ò»¶¨Ö»ÓÐÒ»ÖÖÖ´Ðмƻ®ÊÇ×îÓŵÄ,»¨·Ñʱ¼äÊÇ×îÉٵġ£ÏàÐÅÄãÒ»¶¨»áÓÃPl/sql Developer¡¢ToadµÈ¹¤¾ßÈ¥¿´Ò»¸öÓï¾äµÄÖ´Ðмƻ®,²»¹ýÄã ......

oracleµÄËæ»úÅÅÐò

ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔ­Òò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖظ´¡£
Ô­sqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
 
ºóÀ´½â¾ö°ì·¨£¬²åÈ ......

oracle½«×Ö·û´®×ª»»Îª12СʱÓë24СʱÖÆ£º


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 EBS ϵͳÖ÷Êý¾Ý¹ÜÀí£¨A£©ÕªÂ¼

ϵÁÐÖ®Î壺ORACLE EBS ϵͳÖ÷Êý¾Ý¹ÜÀí£¨A£©
ÎïÁÏÊÇÔÚINVÄ£¿éÖж¨ÒåµÄ£¬¹©Ó¦ÉÌÊÇÔÚAPÄ£¿éÖж¨ÒåµÄ£¬¿Í»§ÊÇÔÚARÄ£¿éÖж¨ÒåµÄ
Èý¸ö³£ÓÃÖ÷Êý¾Ý£ºÎïÁÏ¡¢¹©Ó¦ÉÌÓë¿Í»§¡£ÕâÈý¸öÖ÷Êý¾Ý¶¼ÓÐÒ»¸ö¹²Í¬µÄϵͳʹÓÃÌص㣺¿ç×éÖ¯µÄÈ«¾ÖÐÔ¡£
¶ø¶ÔÓÚBOMÊý¾Ý£¬¾¡¹ÜÔÚÆóҵʵ¼Ê¹ÜÀí¹¤×÷ÖУ¬¿ÉÄܾßÓÐÒ»¶¨µÄÈ«¾ÖÐÔÌص㣨ÀýÈ粻ͬ¹¤³§Éú²úͬÑù² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ