![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
叩叩姐学java
这个作者很懒,什么都没留下…
展开
-
oracle时间转换成long
select to_date('1970-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1483113600000/1000/24/60/60 from dual转载 2016-05-10 19:19:51 · 2930 阅读 · 0 评论 -
dbms_random.value 随机数问题 & 用DBMS_RANDOM生成文本和日期值
ref:http://kb.cnblogs.com/a/95684/ [A]8i以上版本 select * from (select * from tablename order by sys_guid()) where rownum select * from (select * from tablename order by dbms_random.value) where ro转载 2016-05-10 07:58:39 · 1419 阅读 · 0 评论