博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

随笔分类 -  Oracle

摘要:Search the file named "*.ORA" or "tnsnames.ora" in the folders that are related to Oracle. Append the TNS key to tnsnames.ora. 阅读全文

posted @ 2008-07-09 09:28 Snapping 阅读(211) 评论(1) 推荐(0)

摘要:Oracle中:distinct会影响rownum的约束条件。可能是先rownum, 然后再distinct的。select manager_id,manager_name from ( SELECT a.manager_id, a.manager_name, (sysdate-perf_score.max_perf_track_rec (c.track_record_id,'Q'))... 阅读全文

posted @ 2007-07-11 11:46 Snapping 阅读(1558) 评论(0) 推荐(0)