<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[浪漫老猫]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qflamj</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qflamj]]></copyright><item><title><![CDATA[sql语句执行所耗CPU时间]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83703086</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83703086</guid><author>qflamj</author><pubDate>Wed, 01 Sep 2010 15:53:39 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
set statistics time on
select * from tableName
set statistics time off
[/code]]]></description><category></category></item><item><title><![CDATA[oracle触发器实例]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83674039</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83674039</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 17:15:58 +0800</pubDate><description><![CDATA[1、delete触发器
[code=&quot;sql&quot;]
create or replace
TRIGGER &quot;TRWATCH&quot; AFTER
  DELETE ON WATCH FOR EACH ROW DECLARE watchname VARCHAR2(30);
  watchphone VARCHAR2(30);
  starttime DATE;
  endtime DATE;
 ...]]></description><category></category></item><item><title><![CDATA[javascript常用方法]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83674018</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83674018</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 16:52:45 +0800</pubDate><description><![CDATA[[code=&quot;js&quot;]
abs 方法 返回一个数的绝对值。  
acos 方法 返回一个数的反余弦。  
anchor 方法 在对象的指定文本两端加上一个带 NAME 属性的 HTML 锚点。 
asin 方法 返回一个数的反正弦。  
atan 方法 返回一个数的反正切。  
atan2 方法 返回从 X 轴到点 （y, x）的角度（以弧度为单位）。 
atEnd 方法 返回一个表...]]></description><category></category></item><item><title><![CDATA[WebService应用---接口返回参数是List遇到的问题]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83674013</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83674013</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 16:50:15 +0800</pubDate><description><![CDATA[在WebService应用中，如果定义接口中的方法返回参数是List 很可能遇到这样的异常：
[code=&quot;java&quot;]
org.codehaus.xfire.XFireRuntimeException: Cannot create mapping for java.util.List, unspecified component type for interface java.util.Li...]]></description><category></category></item><item><title><![CDATA[jobss5.0安装配置]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83674011</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83674011</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 16:47:07 +0800</pubDate><description><![CDATA[一.下载与安装JBoss 

在本文中，我下载的JBoss版本为：JBOSS5.0 Beta4。

下载地址： [url]http://www.jboss.org/jbossas/downloads/[/url]

在如上的下载页中下载JBOSS5.0 Beta4.zip文件。

下载完成后，将其解压缩后即可完成安装，解压缩后将其放置到一个不带空格的目录(若目录带有空格，例如：C:...]]></description><category></category></item><item><title><![CDATA[oracle数据库存储过程实例（包含游标遍历的应用）]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673923</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673923</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:46:13 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace
PROCEDURE &quot;RAW_LOSEMONTH&quot; (
    dotime IN DATE)   --输入参数
AS
  ammeterIdx VARCHAR2(30);--定义变量
BEGIN
  --定义游标
  DECLARE
    CURSOR cursorbdz
    IS
      SELECT...]]></description><category></category></item><item><title><![CDATA[oracle数据库查询、删除、创建作业]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673916</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673916</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:38:51 +0800</pubDate><description><![CDATA[1、查询作业
[code=&quot;sql&quot;]
select job,what,next_date,next_sec,failures,broken from user_jobs;
[/code]
2、删除作业
[code=&quot;sql&quot;]
begin
     dbms_job.remove(:JOB_NUM);
end;
[/code]
3、创建作业
[code=&quot;sql&quot;]
--...]]></description><category></category></item><item><title><![CDATA[oracle数据库十进制转十六进制]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673902</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673902</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:21:41 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;TENTOHX&quot; (ix IN NUMBER) RETURN VARCHAR2   
IS   
rx VARCHAR2(10);   
ixx NUMBER(10);   
BEGIN   
    rx:='';   
        ixx:=ix;   
    WHILE MOD(i...]]></description><category></category></item><item><title><![CDATA[oracle数据库十进制转二进制]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673901</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673901</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:20:39 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;TENTOBIN&quot; (ix IN NUMBER) RETURN VARCHAR2   
IS   
    vars VARCHAR2(1000);   
  
        xs NUMBER(10);   
BEGIN   
  
    vars:='';   
  
      ...]]></description><category></category></item><item><title><![CDATA[oracle数据库2个数的最小值的函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673899</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673899</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:18:41 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;MIN_TWO&quot; (paramone IN NUMBER,paramtwo IN NUMBER) RETURN NUMBER     
IS   
min_param NUMBER(18,2);   
  
BEGIN   
  
    IF paramone&gt;0 AND paramtwo&gt;0...]]></description><category></category></item><item><title><![CDATA[oracle数据库2个数的最大值的函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673898</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673898</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:17:32 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace
FUNCTION &quot;MAX_TWO&quot; (paramone IN NUMBER,paramtwo IN NUMBER) RETURN NUMBER  

IS

max_param NUMBER(18,2);

BEGIN

	IF paramone&gt;=paramtwo THEN

		max_param:=par...]]></description><category></category></item><item><title><![CDATA[oracle数据库判断是否是数字函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673895</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673895</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:14:49 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;ISNUMERIC&quot; (str IN VARCHAR2)    
RETURN NUMBER    
IS    
v_str FLOAT;    
BEGIN   
IF str IS NULL THEN    
RETURN 0;   
ELSE   
BEGIN   
SELECT ...]]></description><category></category></item><item><title><![CDATA[oracle数据库十六进制转十进制函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673892</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673892</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:11:39 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;HXTOTEN&quot; (str_a IN VARCHAR2) RETURN NUMBER     
IS   
str_b NUMBER(10);   
str_c VARCHAR2(100);   
  
BEGIN   
    str_c:=REPLACE(str_a,'0x','');   ...]]></description><category></category></item><item><title><![CDATA[oracle数据库二进制转十进制函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673890</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673890</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:09:27 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION &quot;BINTOTEN&quot; (strbin in varchar2) return NUMBER     
IS   
  
    decvalue NUMBER(10);   
    binlen NUMBER(10);   
    indexa NUMBER(10);   
    currb...]]></description><category></category></item><item><title><![CDATA[oracle数据库2个时间段的时间差函数]]></title><link>https://blog.youkuaiyun.com/qflamj/article/details/83673889</link><guid>https://blog.youkuaiyun.com/qflamj/article/details/83673889</guid><author>qflamj</author><pubDate>Fri, 23 Jul 2010 14:06:45 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]
create or replace   
FUNCTION DATEDIFF (date1 IN DATE,date2 IN DATE) RETURN NUMBER     
IS   
datesx NUMBER(10);   
secondsx NUMBER(20);   
stra VARCHAR2(19);   
strb VARCHAR2(19);...]]></description><category></category></item></channel></rss>