摘要: http://bash.cyberciti.biz/guide/Perform_arithmetic_operationshttp://www.oracle.com/technetwork/database/focus-areas/manageability/sqlmonitor-084401.htmlhttp://www.eygle.com/archives/2004/10/howto_capture_problem_sql.htmlhttp://space.itpub.net/28985005/viewspace-764378http://www.itpub.net/forum.php?m 阅读全文
posted @ 2013-10-14 19:55 规格严格-功夫到家 阅读(170) 评论(0) 推荐(0)
摘要: oracle trunc(sysdate ,'dd') 日期select trunc(sysdate ,'dd') from dual ; -- 2007-9-19select trunc(sysdate ,'yyyy') from dual ; --2007-1-1select trunc(sysdate ,'mm') from dual ; --2007-9-1begindbms_output.put_line( to_char ( (sysdate) , 'yyyy-mm-dd hh24:mi:ss' ) ) 阅读全文
posted @ 2013-10-14 18:59 规格严格-功夫到家 阅读(295) 评论(0) 推荐(0)