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

OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(¶þ)

15. /*+USE_CONCAT*/
¶Ô²éѯÖеÄWHEREºóÃæµÄORÌõ¼þ½øÐÐת»»ÎªUNION  ALLµÄ×éºÏ²éѯ. (ã¶®°¡,ÏÈ´æ×Å)
ÀýÈç:
select /*+use_concat */ * from emp where deptno=10 OR empno=7788;
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=2 Bytes=174)
   1    0   TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=2 Bytes=174)
16. /*+NO_EXPAND*/
¶ÔÓÚWHEREºóÃæµÄOR »òÕßIN-LISTµÄ²éѯÓï¾ä,
NO_EXPAND½«×èÖ¹Æä»ùÓÚÓÅ»¯Æ÷¶ÔÆä½øÐÐÀ©Õ¹.
SELECT /*+NO_EXPAND*/  *  from  EMP  WHERE DEPTNO=10 AND job='MANAGER';
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=87)
   1    0   TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=1 Bytes=87)
17. /*+NOWRITE*/
½ûÖ¹¶Ô²éѯ¿éµÄ²éÑ¯ÖØÐ´²Ù×÷.
18. /*+REWRITE*/
¿ÉÒÔ½«ÊÓͼ×÷Ϊ²ÎÊý.
19. /*+MERGE(TABLE)*/
Äܹ»¶ÔÊÓͼµÄ¸÷¸ö²éѯ½øÐÐÏàÓ¦µÄºÏ²¢.
20. /*+NO_MERGE(TABLE)*/
¶ÔÓÚÓпɺϲ¢µÄÊÓͼ²»Ôٺϲ¢.
21. /*+ORDERED*/
¸ù¾Ý±í³öÏÖÔÚfromÖеÄ˳Ðò,ORDEREDʹORACLEÒÀ´Ë˳Ðò¶ÔÆäÁ¬½Ó.
SELECT  /*+ORDERED*/  D.DNAME, E.ENAME,E.SAL from EMP E,DEPT D WHERE E.DEPTNO=D.DEPTNO;
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=82 Bytes=4510)
   1    0   HASH JOIN (Cost=5 Card=82 Bytes=4510)
   2    1     TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=82 Bytes=2706)
   3    1     TABLE ACCESS (FULL) OF 'DEPT' (Cost=2 Card=82 Bytes=1804)
¶Ò»»ÏÂEMPºÍDEPTµÄ˳Ðò,µÃµ½
SELECT  /*+ORDERED*/  D.DNAME, E.ENAME,E.SAL from DEPT D, EMP E WHERE E.DEPTNO=D.DEPTNO;
Execution Plan
--------------------


Ïà¹ØÎĵµ£º

oracle 10g undo±í¿Õ¼äʹÓÃÂʾӸ߲»ÏÂbug

¶ÔÓÚUNDO
±í¿Õ¼ä´óСµÄ¶¨ÒåÐèÒª¿¼ÂÇUNDO_RETNETION
²ÎÊý¡¢²úÉúµÄUNDO BLOCKS/
Ãë¡¢UNDO BLOCK
µÄ´óС¡£undo_retention
£º¶ÔÓÚUNDO
±í¿Õ¼äµÄÊý¾ÝÎļþÊôÐÔΪautoextensible,
Ôòundo_retenion
²ÎÊý±ØÐëÉèÖã¬UNDO
ÐÅÏ¢½«ÖÁÉÙ±£ÁôÖÁundo_retention
²ÎÊýÉ趨µÄÖµÄÚ£¬µ«UNDO
±í¿Õ¼ä½«»á×Ô¶¯À©Õ¹¡£¶ÔÓڹ̶¨UNDO
±í¿Õ¼ä ......

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......

ʹÓÃJavaµ÷ÓÃOracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÀý

Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
1¡¢½¨Á¢´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
2¡¢ÏàÓ¦µÄJAVA³ÌÐò
import java.sql.*;
import java.io.OutputStream;
import java.io.Writer;
import java.sq ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value
¡¡¡¡O:select floor(-1.001) value from dual
¡¡¡¡4.È¡Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ