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

oracleÖеÄÉÁ±í¹¦ÄÜ

1.Èç¹ûÄãÎóɾ³ýÁËÊý¾Ý,²»Óú¦ÅÂ,¶Ìʱ¼äÄÚ»¹ÊÇ¿ÉÒÔ»Ö¸´µÄ.
select * from (select * from claim_monitor_dispatch as of timestamp to_date('20091203 08:30:00','yyyymmdd hh24:mi:ss')
)
where to_char(created_date,'yyyymmdd')='20090707'
2.Îóɾ³ý±íÖ®ºóµÄ»Ö¸´,»Ö¸´ÕûÕűí
 flashback table name before drop
3.Îóɾ³ýµÄÊý¾ÝÖ÷Ҫȡ¾öÓڻعö¶Î¿Õ¼äµÄ´óС,ÒÔ¼°±£ÁôµÄʱ¼ä,Á½¸öÖ¸±ê. ÓÃDBAÕʺÅÁ¬ÈëÊý¾ÝºóÓÃÒÔÏÂÃüÁî¿É²é¿´.
show parameter undo


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ROLLUPºÍCUBEÓï¾ä¡£ ORACLE·Ö×éͳ¼Æ

ROLLUPºÍCUBEÓï¾ä¡£
OracleµÄGROUP
BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£Èç¹ûÊÇGROUP BY
CUBE(A, B, C)£¬ÔòÊ×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºóÒÀ´ÎÊÇ(A¡ ......

asp¡¢delphi¡¢oracleµÄ¼¼ÊõÎĵµ×ܽá

1) DelphiÏòoracleÖд«µÝ²ÎÊý ÈçoracleÖеIJÎÊýÃûΪerpcx 
´ð£ºÈç¹ûÏë´Ó±íÀïȡֵµ½oracle£¬Ôòerpcx:=trim(aq1.fieldbyname('erpcx').AsString);
·ñÔòÖ±½ÓÓÿؼþÃû×Ö
Óï¾äΪ
with aperp do    
begin
connection:=dm.ADOCerp;      
parameters.Clear;&nbs ......

ÐèÒªÕÒµ½Ôì³Éoracle Èȵã¿éµÄsql

Ò»°ãÇé¿öÏÂÊǺ¬ÓÐÈ«±íɨÃèµÄsql»áÔì³ÉÈȵã¿é¡£
1¡¢ÕÒµ½×îÈȵÄÊý¾Ý¿éµÄlatchºÍbufferÐÅÏ¢
select   b.addr,a.ts#,a.dbarfil,a.dbablk,a.tch,b.gets,b.misses,b.sleeps   from  
(select   *   from   (select   addr,ts#,file#,dbarfil,dbablk,tch,hladdr   from   x$bh ......

[×ªÔØ]Oracle¿ª·¢ÓëʹÓÃÎÄÕÂÊÕ²Ø

ÊÕ¼¯Ò»Ð©Oracle¿ª·¢ÓëʹÓÃÎÄÕÂ,ÒÔ±ãÓÚºóÐø²éÕÒ.
¡¾»ù´¡Àà¡¿
1.ORACLEº¯Êý´óÈ«
2.Orace³£Óú¯Êý
3.oracle ÈÕÆÚº¯Êý½éÉÜ
4.OracleÖг£ÓõÄto_CharÓ÷¨Ïê½â£¨ÓÐFMTµÄÏêϸÁÐ±í£©
5.ORACLEÖÐÈÕÆÚºÍʱ¼äº¯Êý»ã×Ü(×ªÔØ)
6.SQL ServerºÍOracle³£Óú¯Êý¶Ô±È
7.Oracleº¯ÊýÏê½â
8.Oracle ·ÖÎöº¯ÊýµÄʹÓÃ
9.Oracle for ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ