![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
masterGr
soul
展开
-
oracle jdbc 访问异常
java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by原创 2013-12-12 14:23:43 · 515 阅读 · 0 评论 -
将列的Name换为Comment
在生成的PDM中, Powerdesigner界面-tools-Execute Cmmands-Edit/Run Scripts 运行下列代码 Option Explicit ValidationMode = True InteractiveMode = im_Batch Dim mdl 'the current model 'get the cu转载 2013-11-25 10:36:05 · 490 阅读 · 0 评论 -
oracle 分页语句
1.根据ROWID来分 select * from t_xiaoxi where rowid in(select rid from (select rownum rn,rid from(select rowid rid,cid from t_xiaoxi order by cid desc) where rownum9980) order by cid desc; 执行时间0.03秒转载 2014-10-12 09:52:28 · 412 阅读 · 0 评论