直到世界的尽头

1. 按不同规则查询： //按照笔划排序 select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M'); //按照部首排序 select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_RADICAL_M'); //按照拼音排序，此为系统的默认排序...

先创建用户： 在不同用户登陆界面中： drop user drp cascade; create user drp identified by drp default tablespace users quota 30m on users; grant create session, create table, create view, create trigger, create seq...

select * from ( select rownum rn, t.* from ( select * from t_user ) t where rownum <=4 ) where rn >2