oracle
1_machine
这个作者很懒,什么都没留下…
展开
-
ora-12514
重写listener.ora文件(蓝色为增加部分)SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = f:\oracle\product\10.1.0\Db_1) (PROGRAM = extproc) )原创 2013-12-30 11:03:58 · 390 阅读 · 0 评论 -
oracle分组后合并其中一个字段
select m.parent_id, m.start_date, wmsys.wm_concat(m.cleck_name) As name, wmsys.wm_concat(m.userId) As userId, max(rowid) as rid原创 2014-02-09 09:16:45 · 8878 阅读 · 0 评论 -
oracle start with connect by递归查询
用法:select ... from tablename start with 条件1 connect by 条件2 where 条件3; select * from table start with org_id = 'HBHqfWGWPy' connect by prior org_id = parent_id;条件1 是根结点的转载 2014-02-09 10:33:28 · 500 阅读 · 0 评论 -
row_number() OVER
row_number() OVER (PARTITION BY COL1 ORDER BY COL2)表示根据COL1分组,在分组内部根据 COL2排序,而此函数计算的值就表示每组内部排序后的顺序编号(组内连续的唯一的)SELECT *, Row_Number() OVER (partition by deptid ORDER BY salary desc) rank FROM emp翻译 2014-02-18 13:34:06 · 557 阅读 · 0 评论