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²¢²»»áÈ¡Õûµ½Ä꣬¶øÊÇÈ¡Õûµ½µ±Ç°ÔÂ
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
--1:ÎÞORDER BYÅÅÐòµÄд·¨¡£(ЧÂÊ×î¸ß)
--(¾¹ý²âÊÔ£¬´Ë·½·¨³É±¾×îµÍ£¬Ö»Ç¶Ì×Ò»²ã£¬ËÙ¶È×î¿ì£¡¼´Ê¹²éѯµÄÊý¾ÝÁ¿ÔÙ´ó£¬Ò²¼¸ºõ²»ÊÜÓ°Ï죬ËÙ¶ÈÒÀÈ»£¡)
SELECT *
from (Select ROWNUM AS ROWNO, T.*
from k_task T &s ......
create user Óû§Ãû identified by ÃÜÂë default tablespace ȱʡ±í¿Õ¼ä¡¡Temporary tablespace ÁÙʱ±í¿Õ¼ä;
grant connect,resource,dba to ̞;
¡¡¡¡
revoke unlimited tablespace from ̞;
¡¡¡¡
alter user ̞ quota 0 on Users;
alter user Óû§Ãû¡¡quot ......
Ç°Õó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......