![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
js_miaomiao
这个作者很懒,什么都没留下…
展开
-
oracle进行分组后,取出每组的前几条数据
SELECT * FROM (SELECT 分组的字段名, ROW_NUMBER() OVER(PARTITION BY 分组的字段名 ORDER BY 排序的字段名) AS RN FROM 表名) WHERE RN <= 10 得到分组后,数据的前几条 ...原创 2012-03-21 11:07:02 · 954 阅读 · 0 评论 -
Oracle 表空间记录
select * from dba_tables where tablespace_name='DIGITPARTY' 所有表 DIGITPARTY为表空间名称,区分大小写 select * from user_tables 查看所有表 select * from all_views where owner=‘DIGITPARTY’ 所有视图 DIGITPARTY为用户...原创 2016-03-04 15:17:28 · 120 阅读 · 0 评论 -
oracle 集群配置
jdbc:oracle:thin:@10.196.139.39:1521:DB11G jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = szdjdb1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = szdjdb2)(PORT = 1521))(LOAD_...原创 2016-03-18 00:58:01 · 191 阅读 · 0 评论