摘要：private String getDate(Object value) { Timestamp timestamp = null; try { timestamp = (Timestamp) value; } catch (Exception e) { timestamp = getOracleTimestamp(value); } if(timestamp!=null) return (new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S")) .format(timestamp); else return null; } /** * 阅读全文

摘要：conn / as sysdba 阅读全文

摘要：exp userid=xiaoming/pwd123@orcl owner=xiaoming file=d:\emp5.dmp导出用户名为xiaoming,密码为pwd123,数据库为orcl，拥有者为xiaoming的数据库到d:\emp5.dmp 阅读全文

摘要：于是写测试程序。。。不行下载最新的ODBC。。。还是不行通过sql plus查询。。。咦？竟然也查不到。。。于是，折腾。。。折腾。。。几个小时后，问题找到，原来PL/SQL DEVELOPER 默认不是自动提交，当关掉sql window窗口后或手动commit方进行数据的提交，我靠，真隐晦。。。更改选项，插入，查询，一切OK了，唉，宝贵的时间啊。tool－preferences 阅读全文

摘要：tools->export tables 是导出表结构还有数据tools->export user objects是导出表结构可以用tools->export tables用中间的sql inserts页面，选中create tables选项，where clause 里写入 where rownum<1。如果表包含有CLOB类型字段的话，sql是无法导出的。这时候可以改用PL/SQL的pde格式进行导出。使用pl/sql developer导出oracle表结构及数据 阅读全文

摘要：启动监听:sc start OracleOraDb10g_home1TNSListener启动服务:sc start OracleServiceORCL 阅读全文

摘要：select *from user_constraints a, user_constraints b where a.constraint_type = 'R' and b.constraint_type = 'P' and a.r_constraint_name = b.constraint_name 阅读全文

摘要：http://www.cnblogs.com/jiangchongwei/archive/2011/05/02/2034273.htmlhttp://www.cnblogs.com/reborter/archive/2008/11/28/1343195.html 阅读全文

摘要：http://www.qnr.cn/pc/ora/study/201008/526195.html 阅读全文

摘要：http://blog.csdn.net/ruantao1989/article/details/8147072 阅读全文

摘要：--两个竖线可以把前后两个字符串连接起来select upper(substr(xm,1,1))|| lower(substr(xm,2,length(xm)-1)) from student; 阅读全文

摘要：select * from (select rownum rn , t1.* from ( select * from emp order by empno ) t1 where rownum =5 ;select * from emp where rowid in (select rid from (select rid from (select rownum rn,rid from (select rowid rid ,empno from emp) where rownum =5)) order by empno; 阅读全文