![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
一闪一闪呀
YY,YYDS
展开
-
Oracel 恢复误修改语句
--恢复某一字段10分钟之前的数据update table_name t1 set t1.name= (select name from table_name AS OF TIMESTAMP SYSDATE - 10 / 1440 where t1.rid = rid); ...原创 2019-04-28 11:41:32 · 103 阅读 · 0 评论 -
Oracle 出生日期算年龄
方法一:SELECT t.birth_date,TRUNC(months_between(sysdate, t.birth_date)/12) AS agefrom base_info t方法二:select t.birth_date,TRUNC((to_char(sysdate, 'yyyyMMdd') - to_char(birth_date, 'yyyyMMdd')) / ...原创 2019-10-11 16:49:17 · 392 阅读 · 0 评论