select session_id from v$locked_object;
SELECT sid, serial#, username, osuser FROM v$session where sid in (823,829);
ALTER SYSTEM KILL SESSION '823,15231';
--查询一个表中 中间1/3 三分之一 的数据
select * from v_test_person t;
select *
from (select ID,
NAME,
PASSWORD,
AGE,
COMPANY,
MOBILE,
BIRTHDATE,
rownum rn
from test_person) t
where rn > (select ceil(max(rn) / 3)
from (select ID,
NAME,
PASSWORD,
AGE,
COMPANY,
MOBILE,
BIRTHDATE,
rownum rn
from test_person))
and rn <= (select ceil(max(rn) / 3 * 2)
SELECT sid, serial#, username, osuser FROM v$session where sid in (823,829);
ALTER SYSTEM KILL SESSION '823,15231';
--查询一个表中 中间1/3 三分之一 的数据
select * from v_test_person t;
select *
from (select ID,
NAME,
PASSWORD,
AGE,
COMPANY,
MOBILE,
BIRTHDATE,
rownum rn
from test_person) t
where rn > (select ceil(max(rn) / 3)
from (select ID,
NAME,
PASSWORD,
AGE,
COMPANY,
MOBILE,
BIRTHDATE,
rownum rn
from test_person))
and rn <= (select ceil(max(rn) / 3 * 2)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769555/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
