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
Ïà¹ØÎĵµ£º
ʹÓÃORDER BY×Ӿ䣬ROWNUMÄÚÖú¯ÊýºÍDBMS_RANDOM°üÖеÄÄÚÖú¯ÊýVALUEÀ´ÊµÏÖ
SQL> select * from
2 (
3 select ename,job
4 from emp
5 order by dbms_random.value()
6 )
7 where rownum<=5;
ENAME JOB
---------- ---------
TURNER SALESMAN
SMITH CLERK
MARTIN SA ......
Ö÷Òª·½·¨ÊÇͨ¹ýʹÓÃCASE±í´ïʽÀ´“±ê¼Ç”Ò»¸öÖµÊÇ·ñΪNULL¡£ÕâÀï±ê¼ÇÓÐÁ½¸öÖµ£¬Ò»¸ö±íʾNULL£¬Ò»¸ö±íʾ·ÇNULL¡£ÕâÑù£¬Ö»ÒªÔÚORDER BY×Ó¾äÖÐÔö¼Ó±ê¼ÇÁУ¬±ã¿ÉÒÔºÜÈÝÒ׵ĿØÖÆ¿ÕÖµÊÇÅÅÔÚÇ°Ãæ»¹ÊÇÅÅÔÚºóÃæ£¬¶ø²»»á±»¿ÕÖµËù¸ÉÈÅ¡£
SQL> select ename,sal,comm from emp;
ENAME SAL COMM
----- ......
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¡ ......
QQ:1156316388 Tel:010-51527259
Ò»¡¢Æô¶¯
Èý¸öÃüÁ
1¡¢sqlplux /nolog
2¡¢connect /as sysdba
3¡¢startup
¶þ¡¢¹Ø±Õ
1¡¢shutdown immediate;
[oracle@zhao ......