![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
tec.db
iteye_14299
这个作者很懒,什么都没留下…
展开
-
查询是否需要事务支持 - zt
[size=large] http://www.iteye.com/topic/8850如果只提交一个查询,有必要用事务吗?这个问题之前已经讨论过http://forum.iteye.com/viewtopic.php?t=1603[/size]2008-01-08 14:38:28 · 233 阅读 · 0 评论 -
Spring事务类型详解 - zt
大家可能在spring中经常看到这样的定义:<prop key="load*">PROPAGATION_REQUIRED,readOnly</prop><prop key="store*">PROPAGATION_REQUIRED</prop>估计有好多朋友还没有弄清楚里面的值的意思,仔细看完下面应该知道自己什么情况下面应该使用什么样的声明。^...2008-04-09 16:11:45 · 90 阅读 · 0 评论 -
oracle java.sql.SQLException: 用户身份证明与现有身份证明不匹配
Setting up Oracle JNDI Datasource on Tomcat by Leon van Tegelen In one of the projects I’m involved in we have to make use of specific Oracle JDBC features. The application runs on Tomcat 5.0.27 and...2007-10-16 10:32:37 · 427 阅读 · 0 评论 -
ORACLE的DUAL表-zt
http://hi.baidu.com/honglovejia/blog/item/97961b34f2ad213a5bb5f590.html经常在程序里看到“select sysdate from dual;”查了一下关于DUAL表的资料:1. Dual 是什么? select object_name ,object_type from dba_objects where obje...2007-10-19 13:38:08 · 80 阅读 · 0 评论 -
Oracle-Schema - zt
http://hi.baidu.com/sericalee/blog/item/3d9f02d8866f143533fa1c83.html 我们先来看一下他们的定义:A schema is a collection of database objects (used by a user.). Schema objects are the logical structures that di...2007-10-19 15:58:55 · 72 阅读 · 0 评论 -
select 1 from
QUESTION POSED ON: 17 October 2002 I have a rather simple question: What does "SELECT 1 FROM ..." accomplish? I am debugging a software program that is sending a "SELECT 1" statement to the database, ...2007-11-21 13:55:07 · 89 阅读 · 0 评论 -
oracle jdbc nvarchar2 中文字段排序
相关设置参见http://x-spirit.spaces.live.com/blog/cns!CC0B04AE126337C0!569.entry 可能的性能问题参见http://www.xjinf.com/technology/database/200804/76.html 但是通过JDBC访问时,nvarchar2类型里面的中文排序还是不对解决方式要么是换成varc...原创 2010-01-27 13:12:46 · 278 阅读 · 0 评论 -
给视图添加主键(唯一列值)
参考http://topic.csdn.net/t/20050629/16/4112826.html 产生唯一值很简单 select newid() as 列名,* from 表 http://huamengxing.iteye.com/blog/120162 NEWID ,而Oracle中使用SYS_GUID...2010-05-09 11:39:02 · 8681 阅读 · 0 评论