<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[junjincatvan的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/junjincatvan</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; junjincatvan]]></copyright><item><title><![CDATA[jquery  find 循环 select 元素]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/102582667</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/102582667</guid><author>junjincatvan</author><pubDate>Wed, 16 Oct 2019 11:38:30 +0800</pubDate><description><![CDATA[$("#scarletable").find("select[name='scarletletter']").each(function (i){
     if (this.value == '0') {
         alert("您好，请选择xxxx！");
         this.focus();
     }
 });
]]></description><category></category></item><item><title><![CDATA[oracle 数值加减乘除]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/90297989</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/90297989</guid><author>junjincatvan</author><pubDate>Fri, 17 May 2019 17:58:16 +0800</pubDate><description><![CDATA[运算符含义



·+（加） 加法

·||（加）字符串相加

·-（减） 减法

·*（乘） 乘法

·/（除） 除法

·mod（模）返回一个除法的整数余数



例如，12 % 5 = 2，这是因为 12 除以 5，余数为 2




示例：select5+6,5+nullfromdualselect5-6fromdualselect5*6from...]]></description><category></category></item><item><title><![CDATA[oracle中instr()函数用法]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/90204481</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/90204481</guid><author>junjincatvan</author><pubDate>Tue, 14 May 2019 13:35:43 +0800</pubDate><description><![CDATA[instr(name,'张三')&gt;0 相当于 name like '%张三%'
instr(name,'张三')=1 相当于 name like '张三%'
instr(name,'张三')=0 相当于 name not like '%张三%'
实验得出，在一个2亿多条记录的表中，同时8个并行，使用like查询很久都不出来结果，但使用instr,4分钟即完成查找，性能是相当的好...]]></description><category></category></item><item><title><![CDATA[JQuery设置和去除disabled属性的方法总结]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/87694125</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/87694125</guid><author>junjincatvan</author><pubDate>Tue, 19 Feb 2019 10:59:14 +0800</pubDate><description><![CDATA[//两种方法设置disabled属性
$('#属性id').attr(&quot;disabled&quot;,true);
$('#属性id').attr(&quot;disabled&quot;,&quot;disabled&quot;);
//三种方法移除disabled属性
$('#属性id').attr(&quot;disabled&quot;,false);
$('#属性id').removeAttr(&quot;disabled&quot;);
$('#属性id').attr(&quot;d.]]></description><category></category></item><item><title><![CDATA[where 条件中 使用 instr 替代 in]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/69674057</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/69674057</guid><author>junjincatvan</author><pubDate>Sat, 08 Apr 2017 15:43:00 +0800</pubDate><description><![CDATA[select  * from  expense  ee 
where ee.pro_ype = processType 
and ee.cost_type in ( DECODE(processType,'1','1,2','2','2','') ) 


processType 为传进来的参数

相当于根据传进来的值分别得到不同的查询语句：
1.  select  * from]]></description><category></category></item><item><title><![CDATA[oracle 函数返回数据集（如list）]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/69664749</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/69664749</guid><author>junjincatvan</author><pubDate>Sat, 08 Apr 2017 09:19:24 +0800</pubDate><description><![CDATA[--说明：Oracle函数中无法传递大于4000个字符长度的字符，
--可通过以下方法解决：建个临时表，当做list 来存储数据，将要存储的数据都传进该临时表内，然后结果中返回该临时表
--创建表结构类型
CREATE OR REPLACE TYPE JG_TEST_TYPE AS OBJECT (unintinfo VARCHAR2 (1024));
--创建嵌套表类型
CREATE]]></description><category></category></item><item><title><![CDATA[oracle 没有 limit用法，但有伪列 rownum]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/52386869</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/52386869</guid><author>junjincatvan</author><pubDate>Wed, 31 Aug 2016 17:06:30 +0800</pubDate><description><![CDATA[oracle 没有 limit用法，但有伪列 rownum]]></description><category></category></item><item><title><![CDATA[Java 数字转换为汉语中人民币的大写]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/51481989</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/51481989</guid><author>junjincatvan</author><pubDate>Mon, 23 May 2016 15:24:42 +0800</pubDate><description><![CDATA[Java代码： 数字转换为汉语中人民币的大写
有效范围：
    * max: 9999 9999 9999 9998.99
    * min: -9999999999999998.99]]></description><category></category></item><item><title><![CDATA[oracle union 和union all 的区别]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/49883989</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/49883989</guid><author>junjincatvan</author><pubDate>Tue, 17 Nov 2015 10:20:10 +0800</pubDate><description><![CDATA[假设我们有一个表Student，包括以下字段与数据：

drop table student;


create table student
(
id int primary key,
name nvarchar2(50) not null,
score number not null
);


insert into student values(1,'Aaron',7]]></description><category></category></item><item><title><![CDATA[PL/SQL 创建新用户、删除用户及用户权限的开通]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/45843913</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/45843913</guid><author>junjincatvan</author><pubDate>Tue, 19 May 2015 13:51:43 +0800</pubDate><description><![CDATA[1、创建新用户
利用PL/SQL工具创建，File--->New--->user,打开创建新用户界面，所界面上内容，依次输入 NAME,PASSWOERD,DEFAULT TABLESPACE,TEMPORARY TABLESPACE 内容后，下面"APPLY"按钮会显示，点击“APPLY”后，新用户就创建OK；
2. 給用戶開通權限命令：
Grant
Create session,cre]]></description><category></category></item><item><title><![CDATA[PLSQL 导入导出数据库]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/45672869</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/45672869</guid><author>junjincatvan</author><pubDate>Tue, 12 May 2015 18:01:12 +0800</pubDate><description><![CDATA[导出步骤：
1 tools ->export user object 选择选项，导出.sql文件
2 tools ->export tables-> Oracle Export 选择选项导出.dmp文件
导入步骤：
1 tools->import tables->SQL Inserts 导入.sql文件
2 tools->import talbes->Oracle Import然]]></description><category></category></item><item><title><![CDATA[数据库表结构设计方法及原则]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/44923027</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/44923027</guid><author>junjincatvan</author><pubDate>Tue, 07 Apr 2015 17:12:23 +0800</pubDate><description><![CDATA[在目前的企业信息系统中，数据库还是最佳的数据存储方式，虽然已经有很多的书籍在指导我们进行数据库设计，但应该那种方式是设计数据库的表结构的最好方 法、设计时应遵从什么样的原则、四个范式如何能够用一种方式达到顺畅的应用等是我一直在思考和总结的问题，下文是我针对这几个问题根据自己的设计经历准备 总结的一篇文章的提纲，欢迎大家一块进行探讨，集思广益。其中提到了领域建模的概念，但未作详细解释，希望以后能够有]]></description><category></category></item><item><title><![CDATA[Spring 让 LOB 数据操作变得简单易行]]></title><link>https://blog.youkuaiyun.com/junjincatvan/article/details/42103667</link><guid>https://blog.youkuaiyun.com/junjincatvan/article/details/42103667</guid><author>junjincatvan</author><pubDate>Tue, 23 Dec 2014 15:47:30 +0800</pubDate><description><![CDATA[http://www.ibm.com/developerworks/cn/java/j-lo-spring-lob/]]></description><category></category></item></channel></rss>