ORACLE²åÈëÈÕÆÚÊý¾Ý
oracleÊý¾Ý¿â²åÈëÈÕÆÚÐÍÊý¾Ý
ÍùOracleÊý¾Ý¿âÖвåÈëÈÕÆÚÐÍÊý¾Ý£¨to_dateµÄÓ÷¨£©
½ñÌìÅöµ½ÁËÐèÒªÍùOracleÊý¾Ý¿âÖвåÈëÈÕÆÚÐÍÊý¾Ý£¬ÒªÊ¹ÓÃTO_DATEº¯Êý£¬ÔÚÍøÉÏ·¢ÏÖһƪдµÄ²»´íµÄÎÄÕ£¬ÕªÀ´Ò»Æð·ÖÏí¡£
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-20 18:31:34' , 'YYYY-MM-DD HH24:MI:SS' ) ) ;
²éѯÏÔʾ£º2007-12-20 18:31:34.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-14 14:10' , 'YYYY-MM-DD HH24:MI' ) );
²éѯÏÔʾ£º2007-12-14 14:10:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-14 14' , 'YYYY-MM-DD HH24' ) );
²éѯÏÔʾ£º2007-12-14 14:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-11-15' , 'YYYY-MM-DD' ) );
²éѯÏÔʾ£º2007-11-15 00:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-09' , 'YYYY-MM' ) );
²éѯÏÔʾ£º2007-09-01 00:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007' , 'YYYY' ) );
²éѯÏÔʾ£º2007-05-01 00:00:00.0
-------------------
µ±Ê¡ÂÔHH¡¢MIºÍSS¶ÔÓ¦µÄÊäÈë²ÎÊýʱ£¬OracleʹÓÃ0×÷ΪDEFAULTÖµ¡£
Èç¹ûÊäÈëµÄÈÕÆÚÊý¾ÝºöÂÔʱ¼ä²¿·Ö£¬Oracle»á½«Ê±¡¢·Ö¡¢Ã벿·Ö¶¼ÖÃΪ0£¬Ò²¾ÍÊÇ˵»áÈ¡Õûµ½ÈÕ¡£
ͬÑù£¬ºöÂÔÁËDD²ÎÊý£¬Oracle»á²ÉÓÃ1×÷ΪÈÕµÄĬÈÏÖµ£¬Ò²¾ÍÊÇ˵»áÈ¡Õûµ½Ô¡£
µ«ÊÇ£¬²»Òª±»ÕâÖÖ“¹ßÐÔ”ËùÃÔ»ó£¬Èç¹ûºöÂÔMM²ÎÊý£¬Oracle²¢²»»áÈ¡Õûµ½Ä꣬¶øÊÇÈ¡Õûµ½µ±Ç°ÔÂ
Ïà¹ØÎĵµ£º
1.GSD global services daemon
oracle¹Ù·½ÎĵµµÄÃèÊö
The Global Services Daemon (GSD) runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative ......
²éѯʱ¿ÉÒÔÖ¸¶¨Ê¹ÓÃË÷ÒýµÄд·¨¡£
SELECT /*+ index(TB_ALIAS IX_G_COST3) */
TB_ALIAS.*
from g_Cost TB_ALIAS
WHERE Item_Two = 0
AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')
AND Flight_D ......
Èç¹ûÊÇÖÐÎÄ×Ö·û¼¯£º
[TEST@ora10gr1#2009-11-25/08:39:38]
SQL>create table t1(t timestamp);
Table created.
[TEST@ora10gr1#2009-11-25/08:39:56]
SQL>insert into t1 values(to_timestamp('21NOV09 10:04:12.032','DDMONYY HH24:MI:SS.FF'));
* ERROR at li ......
·ÖÀࣺOracle
Ò»£®ÒýÑÔ
ORACLEÊý¾Ý¿â×Ö·û¼¯£¬¼´OracleÈ«Çò»¯Ö§³Ö(Globalization Support)£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLEΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle¿ÉÒÔÖ§³Ö ......
Ç°Õó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......