![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle基础
venceinfo
这个作者很懒,什么都没留下…
展开
-
sql小结(1)
------------------------- //oracle的分页 select * from (select t. * , rownum as linenum from t_person t where rownum < 10 ) where linenum > 4; select * from T_person t where t.fatherid = 0 connect by prior t.id = t.fatherid; ----------原创 2009-12-31 18:48:11 · 57 阅读 · 0 评论 -
sql基础(3)
统权限和表级权限 select * from user_sys_privs; select * from user_tab_privs; //查看表的相关信息,如大小,所属表空间 select * from user_segments t order by t.segment_type; //查看索引的大小 select sum(bytes)/(1024*1024) as "size(M)" from user_segments t where t.segment_n原创 2010-02-08 14:17:21 · 52 阅读 · 0 评论 -
sql(4)
EGORIES), SAL_RANGE = (SELECT MAX(SAL_RANGE) FROM EMP_CATEGORIES) WHERE EMP_DEPT = 0020; 高效: UPDATE EMP SET (EMP_CAT, SAL_RANGE) = (SELECT MAX(CATEGORY) , MAX(SAL_RANGE) FROM EMP_CATEGORIES原创 2010-02-08 14:35:32 · 50 阅读 · 0 评论 -
转载一篇
ying to issue the kill will hang for 60 seconds and then return this “session marked for kill” message. And the target session does not get killed at all. So why is that? The issue is in what this alter system kill command is doing. It’s not actually kil2010-03-30 12:04:40 · 78 阅读 · 0 评论