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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ö÷Òª·½·¨ÊÇͨ¹ýʹÓÃCASE±í´ïʽÀ´“±ê¼Ç”Ò»¸öÖµÊÇ·ñΪNULL¡£ÕâÀï±ê¼ÇÓÐÁ½¸öÖµ£¬Ò»¸ö±íʾNULL£¬Ò»¸ö±íʾ·ÇNULL¡£ÕâÑù£¬Ö»ÒªÔÚORDER BY×Ó¾äÖÐÔö¼Ó±ê¼ÇÁУ¬±ã¿ÉÒÔºÜÈÝÒ׵ĿØÖÆ¿ÕÖµÊÇÅÅÔÚÇ°Ãæ»¹ÊÇÅÅÔÚºóÃæ£¬¶ø²»»á±»¿ÕÖµËù¸ÉÈÅ¡£
SQL> select ename,sal,comm from emp;
ENAME SAL COMM
----- ......
radhat 5.2ϰ²×°oracle10g
1¡¢ÏµÍ³ÐèÇó£º
Äڴ棺ÖÁÉÙ512mb£¬ÍƼöÓÃ1g£»
Ó²ÅÌ£º·þÎñÆ÷ÖÁÉÙ60g£»
£¨Ò»°ãÇé¿öÏÂÓ²¼þ¶¼ÄÜ·ûºÏÒªÇó£©
Èí¼þ°ü£ºglibc-2.3.2, libaio-0.3.96
½»»»¿Õ¼ä:
RAM: 0~256MB, SWAP: 3 ±¶ RAM ´óС
RAM: 256~512MB, SWAP: 2 ±¶ RAM ´óС
RAM: >=512MB, SWAP: 10 ......
Ò».Êý¾Ý¿ØÖÆÓï¾ä (DML) ²¿·Ö
1.Insert (ÍùÊý¾Ý±íÀï²åÈë¼Ç¼µÄÓï¾ä)
Insert INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2, ……) VALUES ( Öµ1, Öµ2, ……);
&nb ......
ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHA ......