DB
xiaoqforever
这个作者很懒,什么都没留下…
展开
-
mysql查询随机1条,5条
//随机1条SELECT * FROM zhuizhu_weixin AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM zhuizhu_weixin)-(SELECT MIN(id) FROM zhuizhu_weixin))+(SELECT MIN(id) FROM zhuizhu_weixin)) AS id) AS t原创 2013-11-14 13:37:01 · 1004 阅读 · 0 评论 -
ORACLE死锁接触方法:
1:执行以下语句查询死锁内容SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#, l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS ,s.TERMINAL FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID; 2:转载 2014-05-29 13:38:55 · 817 阅读 · 0 评论 -
ORACLE 一些函数
select replace(decode('12',0,'0.00',to_char(12,9999999999.99)),' ','') from dual;select * from( select * from t_user_login_log where to_date(LOGIN_TIME,'yyyy.mm.dd hh24.mi.ss') between (sysd原创 2014-05-29 21:50:44 · 647 阅读 · 0 评论 -
SQL中的INNER JOIN和JOIN有什么区别
Table Aaid adate1 a12 a23 a3TableBbid bdate1 b12 b24 b4两个表a,b相连接,要取出id相同的字段select * from a inner join b on a.aid = b.bid这是仅取出匹配的数据.此时的取出的是:1 a1 b12 a2 b2那么le转载 2014-05-29 21:56:20 · 2977 阅读 · 1 评论 -
oracle常用设置
1,登录后默认自动选中My Objects默认情况下,PLSQL Developer登录后,Brower里会选择All objects,如果你登录的用户是dba,要展开tables目录,正常情况都需要Wait几秒钟,而选择My Objects后响应速率则是以毫秒计算的。Tools菜单 --> Object Brower Filters,会打开Brower Folders的定单窗口,把“My转载 2014-05-30 17:08:15 · 3597 阅读 · 0 评论 -
ORACLE 计算时间相减间隔
1.计算天数select sysdate- to_date('2009-07-14 12:00:0' ,'yyyy-mm-dd hh24:mi:ss') from dual;2.计算小时数select (sysdate- to_date('2009-07-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))*24 from dual;3.计算分钟数sel原创 2014-05-29 20:20:37 · 8276 阅读 · 0 评论