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

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²¢²»»áÈ¡Õûµ½Ä꣬¶øÊÇÈ¡Õûµ½µ±Ç°ÔÂ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLE·ÖÒ³²éѯSQLÓï·¨


--1:ÎÞORDER BYÅÅÐòµÄд·¨¡£(ЧÂÊ×î¸ß) ­
--(¾­¹ý²âÊÔ£¬´Ë·½·¨³É±¾×îµÍ£¬Ö»Ç¶Ì×Ò»²ã£¬ËÙ¶È×î¿ì£¡¼´Ê¹²éѯµÄÊý¾ÝÁ¿ÔÙ´ó£¬Ò²¼¸ºõ²»ÊÜÓ°Ï죬ËÙ¶ÈÒÀÈ»£¡) ­
SELECT * ­
  from (Select ROWNUM AS ROWNO, T.* ­
           from k_task T &s ......

ORACLEÊý¾Ýµ¼Èëµ½Ö¸¶¨µÄ±í¿Õ¼ä

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 ......

ORACLEÖÐÒ»¸öUPDATEµÄ²Ù×÷Á÷³Ì

Ç°Õó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
      i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ