js_miaomiao的博客

SELECT *    FROM  (SELECT 分组的字段名,                                 ROW_NUMBER() OVER(PARTITION BY 分组的字段名 ORDER BY 排序的字段名) AS RN                      FROM 表名)    WHERE RN <= 10   得到分组后,数据的前几条   ...

select * from dba_tables where tablespace_name='DIGITPARTY'   所有表 DIGITPARTY为表空间名称，区分大小写 select * from user_tables 查看所有表   select *  from all_views where owner=‘DIGITPARTY’  所有视图   DIGITPARTY为用户...

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_...