![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle相关
iteye_494
这个作者很懒,什么都没留下…
展开
-
Oracle 常用命令
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'); //按照拼音排序,此为系统的默认排序...原创 2014-05-05 09:06:28 · 55 阅读 · 0 评论 -
oracle 里面创建用户命令
先创建用户: 在不同用户登陆界面中: 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...原创 2014-05-05 09:06:37 · 109 阅读 · 0 评论 -
Oracle分页,采用三层嵌套
select * from ( select rownum rn, t.* from ( select * from t_user ) t where rownum <=4 ) where rn >2原创 2014-05-06 09:28:04 · 299 阅读 · 0 评论