![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
J2EE之数据库相关
caine-fang
这个作者很懒,什么都没留下…
展开
-
安装ORACLE 11R2 问题
原创 2012-02-06 11:08:45 · 53 阅读 · 0 评论 -
SQL之AND OR
-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:ss') <= to_date('2014-05-01 00:00', 'yyyy-mm-dd hh24:mi:ss') and to_date(to_char(icupatient0_.OUT_ICU_TIME, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:ss') >= to_date('22014-05-27 17:34:36 · 61 阅读 · 0 评论 -
PLSQL连接64位oracle
n/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip下载需要登录,得先在Oracle注册账号才能下载!2、解压将下载到的将其解压,如我解压到了 E:\app\instantclient_11_23、设置PLSQL Developer在工具-首选项,连接,OCI库输入e:\app\instantclient_11_2\oci.dll如下图:4、添加环境变量添加环境变量系统变量中添加2个:第一个是指向TNS文件所在目录的,这个目录是你安装原创 2014-01-01 18:02:10 · 79 阅读 · 0 评论 -
You cannot set autocommit during a managed transaction
ts pretty straight forward. You cannot set autocommit during a managed transaction. Try setting the transaction type to BMT (bean-managed transaction) if you want to modify the settings. Speaking of which, why are you setting autocommit at all? If there's原创 2013-10-12 13:37:23 · 364 阅读 · 0 评论 -
SQL语句处理备注
ing;--创建Jobhttp://www.cnblogs.com/conqueror/archive/2010/10/10/1847085.html--ORACLE日期操作http://www.iteye.com/topic/150762 h2:Exception in thread "main" org.h2.jdbc.JdbcSQLException: Database may be already in use: Locked by another p原创 2013-05-23 11:11:32 · 173 阅读 · 0 评论 -
帐号解锁
2013-04-03 14:58:33 · 94 阅读 · 0 评论 -
ORACLE11g 修改字符集
原创 2012-09-04 18:46:20 · 66 阅读 · 0 评论 -
oracle本地NET服务名配置tnsnames.ora格式
乎从oracle自带的配置工具配置,居然下一步点了没反应,推测是解析配置文件错误,恢复该配置文件,用oracle自带工具配置成功。事后分析该文件,发现是手工添加时多了一个空格,原来是空格在作怪。LOCAL_ORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =原创 2012-04-09 16:14:05 · 86 阅读 · 0 评论 -
oracle10g 释放表空间
原创 2012-04-09 16:11:00 · 67 阅读 · 0 评论 -
oracle查询某用户下所有表记录数
原创 2012-04-09 16:10:01 · 66 阅读 · 0 评论 -
sqlserver 存储过程
ml原创 2012-03-27 16:25:01 · 56 阅读 · 0 评论 -
ORACLE 函数
e’,’i’) from dual; REPLACE(’H ---------- i love you原创 2012-03-20 16:20:45 · 47 阅读 · 0 评论 -
bat 执行sql
pwd%@%oracle_ds% @clean.sql >> clean.logecho 执行删除命令完成pause2014-08-21 16:37:20 · 73 阅读 · 0 评论