- 博客(280)
- 资源 (28)
- 收藏
- 关注
转载 select for update nowait 与 select for update 区别
nowait的含义很多人都会误解为“不用等待,立即执行”。但实际上该关键字的含义是“不用等待,立即返回”如果当前请求的资源被其他会话锁定时,会发生阻塞,nowait可以避免这一阻塞,因为If another user is in the process of modifying that row, we will get an ORA‐00054Resource Busy error.
2014-05-15 18:38:02 844
转载 ORA-10635: Invalid segment or tablespace type
原文地址:http://www.cnblogs.com/kerrycode/archive/2013/07/17/3196807.html上周星期天在迁移数据时,碰到了ORA-10635: Invalid segment or tablespace type 错误,当时的操作环境如下:操作系统版本:[oracle@xxxxx scripts]$ more /etc/issue Re
2014-05-13 23:03:11 1533
转载 更改Oracle字符集
更改服务器字符集为ZHS16GBK[/COLOR]SQL> update props$ set value$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET';1 row updated.SQL> COMMIT;更改客户端字符集为ZHS16GBK[/COLOR]D:\>SET NLS_LANG=AMERICAN_AMERICA.ZHS
2014-04-12 17:33:51 657
原创 javaweb项目+域名+tomcat 发布
首先修改tomcat中server.xml文件,两处:<Connector port="80" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" /><Host name="***.com.cn" appBase="E:/tomca
2014-04-03 11:55:30 2991 1
原创 Oracle 字段拼接
将news表中的htmlpath修改成为'news/news.jsp?nid=' + 本行iddeclare rn varchar2(20) :='news/news/jsp?nid='; n number := 0;begin for cl in (select id from news order by id) loop
2014-03-20 11:45:14 1021
原创 easyUI datagrid layout
frozenColumns:[[ { title:"预混ID", field:"mixOid", hidden:true },{ title:"预混编号", field:"mixOcard", align:"center", sortable:true }]],columns:[[ { title:"半成品", field:"
2014-03-17 17:23:29 783
原创 easyUI datagrid触发事件
onCheck : function(rowIndex,rowData){ $("#datagridB").datagrid('beginEdit',rowIndex); var nums = rowData.num; var origin_num = $("#mixNumber").val(); var total = Number(origin_num) + Number(nu
2014-03-17 17:19:15 6209
原创 JavaScript 数字操作
var nums = rowData.num;var origin_num = $("#mixNumber").val();var total = Number(origin_num) + Number(nums);$("#mixNumber").val(total);
2014-03-17 17:15:25 576
转载 Oracle的rollup、cube、grouping sets函数
Oracle的group by除了基本用法以外,还有3种扩展用法,分别是rollup、cube、grouping sets。1 rollup假设有一个表test,有A、B、C、D、E5列。如果使用group by rollup(A,B,C),首先会对(A、B、C)进行GROUP BY,然后对(A、B)进行GROUP BY,然后是(A)进行GROUP BY,最后对全表进行GROUP BY
2014-03-13 09:04:23 794
原创 PL/SQL连接远程oracle
PL/SQL连接远程oracle网上查资料,一大堆的设置,还要在PL/SQL中设置路径,配置神马oci.dll,要是要使用本地的Oracle又的设置回来,想想就头疼,最简单的办法:方法一:打开PL/SQL,输入username和password,database中输入:ip地址/服务名就可以登录;方法二:无状态打开PL/SQL,打开Command Window,输入:conne
2014-03-01 22:20:13 749
转载 Oracle 字符集的查看和修改
一、什么是Oracle字符集 Oracle字符集是一个字节数据的解释的符号集合,有大小之分,有相互的包容关系。ORACLE 支持国家语言的体系结构允许你使用本地化语言来存储,处理,检索数据。它使数据库工具,错误消息,排序次序,日期,时间,货币,数字,和日历自动适应本地化语言和平台。 影响Oracle数据库字符集最重要的参数是NLS_LANG参数。它的格式
2014-03-01 14:07:22 628
原创 svn out of date
svn提交项目提示:*** out of date错误原因是本地的资源文件版本不是服务器上面最新的版本,需要先更新(及时备份),再提交。
2014-02-27 09:55:20 683
原创 Backups stored in the fast recovery area cannot be marked as unavailable.
Backups stored in the fast recovery area cannot be marked as unavailable.
2014-02-21 07:40:27 702
原创 svn ***** already locked
svn提交class报告already clocked警告解决办法:在要提交的类、包或者项目上点击右键,点击Refresh/Clearup,然后就可以完成提交。
2014-02-17 10:47:05 602
翻译 SYS and SYSTEM Users
SYSThis account can perform all administrative functions. All base (underlying) tables and views for the database data dictionary are stored in the SYS schema. These base tables and views are crit
2014-02-15 23:30:46 753
翻译 Oracle Database Background Processes
Background Process Description后台进程描述Database writer (DBWn) The database writer writes modified blocks from the database buffer cacheto the files on a disk. Oracle Database allows a maximum of
2014-02-10 23:30:13 656
转载 ORA-12560: TNS:协议适配器错误
原文地址:点击打开链接启动sqlplus,然后登陆数据库,出现错误,具体信息如下:C:/Documents and Settings/netshong>sqlplusSQL*Plus: Release10.2.0.1.0 - Production on星期一7月24 13:46:02 2006Copyright (c) 1982, 2005, Oracle. All
2014-02-09 21:27:36 762
原创 进入Oracle企业管理器
进入Oracle企业管理器首先需要启动OracleDBConsoleorcl服务;URL格式:https://hostname:portnumber/emhostname也可以是主机IP,portnumber是1158,而不是Net Manager中的端口号;例如:https://localhost:1158/em备注:URL也可以在{Oracle_home}\product\
2014-02-09 18:58:43 1774
原创 Installing Oracle Software and Building the Database
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/install/install.htm
2014-02-09 17:22:47 548
翻译 Oracle一To create templates
To create templates■ From an existing templateUsing an existing template, you can create a new template based on the predefined template settings. You can add or change any template settings such
2014-02-09 16:58:37 832
翻译 The advantages of the archiving of online redo log files
The advantages of the archiving of online redo log files■ A database backup, with online and archived redo log files, guarantees that you can recover all committed transactions if the operating sy
2014-02-08 15:17:01 677
翻译 Typical Install Configuration
■ Oracle Base Location— The Oracle base directory helps to facilitate the organization of multiple Oracle software installations.If you did not set the ORACLE_BASE environment variable before starting
2014-02-08 10:48:26 1198
转载 三种东西永远不要放到数据库里
原文链接:点击打开链接导读:作者Frank Wiles发表了一篇博文,Frank Wiles曾在很多演讲里说过,改进你的系统的最好的方法是先避免做“蠢事”。并不是说你或你开发的东西“蠢”,只是有些决定很容易被人们忽略掉其暗含的牵连,认识不到这样做对系统维护尤其是系统升级带来多大的麻烦。作为一个顾问,像这样的事情我到处都能见到,我还从来没有见过做出这样的决定的人有过好的结果的。
2014-02-08 09:15:39 491
翻译 Oracle --- About Advanced Installation
During advanced installations using the Server Class method you are prompted to make the additional choices listed in this section, and the choices for a typical installation. The installation process
2014-02-07 23:41:55 870
翻译 Oracle Installation Type
When you install Oracle Database during basic and advanced installations, you need answers for the questions listed in this section. OUI provides default values for every choice.当你在安装Oracle基本版和高级版的时
2014-02-07 22:07:07 980
翻译 Tools for Administering the Database
The following are some products, tools, and utilities you can use toachieve your goals as a database administrator:以下是一些产品、工具和通用设施,你可以使用它们来完成数据库管理员的职责。■ Oracle Universal InstallerOracle Univer
2014-02-07 10:49:43 654
翻译 About Oracle Database
Oracle Database is a relational database with object and Extensible Markup Language (XML) capabilities. In a relational database, all data is stored in two-dimensional tables that are composed of rows
2014-02-07 02:00:01 668
原创 myeclipse 文件默认打开方式设置
FIle types中选择jsp,在Associated editors中选择需要的打开方式,点击Default即可。
2014-01-23 11:25:59 703
原创 easyui ajax返回数据后刷新页面
$.ajax({ type : "post", url : "${pageContext.request.contextPath}/expros!addExProsInfo.do", data : data, success : function(items) { $("#exnotice").html(""); if(items == 'no') { alert("出库失败
2014-01-22 10:14:42 7541
原创 java File读写
import java.io.BufferedReader;import java.io.BufferedWriter;import java.io.File;import java.io.FileReader;import java.io.FileWriter;import java.io.IOException;/** * @author pc2013 * */publ
2014-01-21 20:02:26 667
原创 easyui 获取numberbox值
numberbox定义:{ field:'exWarehouseNumber', title:'出库数量', width:80, editor:{ type:'numberbox' , options:{ min:0, precision:0, } }}onClickRow函数:onClickRow : function(rowIndex,rowData
2014-01-21 18:15:12 5087
原创 java 获取当前格式化时间
目标:获取当前格式化时间方式一:Timestamp t = new Timestamp(System.currentTimeMillis());int year = t.getYear() + 1900;int month = t.getMonth() + 1;int day = t.getDay();int hour = t.getHours();int minute = t.
2014-01-21 10:13:54 987
原创 is not mapped [from
tomcat报异常:storage is not mapped [from storage s where 1=1]错误原因:from storage s where 1=1中的storage是类名,首字母没大写,纠结了三小时,头疼,叫同事过来一秒种就解决,FUCK HIBERNATE!!!
2014-01-18 17:57:25 689
原创 easyUI 下拉列表
easyUI 下拉列表在$(function(){}函数中写ajax事件,当页面出后后加载数据到列表中$('#exman').combobox({ url:"${pageContext.request.contextPath }/staff!staffName.do", valueField:"id", textField:"text"//, });备注:id
2014-01-18 15:51:10 971
原创 jQuery ajax传参方式
方式1:直接附加到url后边url : "${pageContext.request.contextPath}/sale!getExProValue.do?data=admin",方式2:放在data属性中url : "${pageContext.request.contextPath}/sale!getExProValue.do",data:"exman=" + exman + "
2014-01-18 09:49:41 1294
原创 EasyUI datagrid获取一行数据
EasyUI datagrid获取表格中被选中的数据var row = $('#target').datagrid('getSelected');也可以获取所有被选中的行:
2014-01-17 18:33:27 7927
原创 EasyUI 加入数字框
columns: columns:[[ { field:'productsType', title:'产品类型', width:80, },{ field:'warehouseInNumber', title:'入库数量', width:80 },{
2014-01-17 18:29:56 1432
原创 Struts2中的ModelDriven机制及其运用
为什么需要ModelDriven 所谓ModelDriven ,意思是直接把实体类当成页面数据的收集对象。比如,有实体类User 如下: package cn.com.leadfar.struts2.actions; public class User { private int id ; private String usern
2014-01-16 16:03:30 563
原创 myeclipse svn地址
http://subclipse.tigris.org/servlets/ProjectDocumentList?folderID=2240
2014-01-16 12:59:58 606
The Swift Programming Language中文完整版(CocoaChina精校)
2015-11-01
[Oracle.Core:Essential.Internals.for.DBAs.and.Developers].Jonathan.Lewis.文字版
2013-12-30
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人