直到世界的尽头

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