<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[iteye_13422的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_13422</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_13422]]></copyright><item><title><![CDATA[table拆分]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81925930</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81925930</guid><author>iteye_13422</author><pubDate>Wed, 08 Sep 2010 14:23:05 +0800</pubDate><description><![CDATA[oracle:

insert all 
when 条件1 then into 目的表1名称(目的表1字段名) values(对应目的表1字段的源表字段名) 
when 条件2 then into 目的表2名称(目的表1字段名) values(对应目的表2字段的源表字段名) 
select 源表字段 from 源表;

[color=red]将源表的数据根据不同的条件插入到不同的目的...]]></description><category></category></item><item><title><![CDATA[用户无权登录PL/SQL Dev]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81896553</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81896553</guid><author>iteye_13422</author><pubDate>Tue, 27 Jul 2010 09:25:12 +0800</pubDate><description><![CDATA[[转载]http://hi.baidu.com/xxoo_0/blog/item/67bde11136923b085baf5301.html

登录PL/SQL Developer
总是出现提示：
You are not allowed to use PL/SQL Developer on this database.
You do not have the System.Logon p...]]></description><category></category></item><item><title><![CDATA[查询存储过程中调用表情况(oracle)]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81890322</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81890322</guid><author>iteye_13422</author><pubDate>Tue, 06 Jul 2010 14:36:35 +0800</pubDate><description><![CDATA[使用下列语句可以查询存储过程中引用了哪些表.

select *
  from user_dependencies t
 where t.type = 'PROCEDURE'
   and t.referenced_type = 'TABLE'
   and t.NAME = '存储过程名称';...]]></description><category></category></item><item><title><![CDATA[Report studio 操作技巧]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81833935</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81833935</guid><author>iteye_13422</author><pubDate>Thu, 25 Mar 2010 14:36:21 +0800</pubDate><description><![CDATA[cognos Report studio 操作技巧:
1.不分页显示:
选择列表,将分页行数值设置大点.]]></description><category></category></item><item><title><![CDATA[java.lang.OutOfMemoryError: Java heap space]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81822854</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81822854</guid><author>iteye_13422</author><pubDate>Tue, 02 Feb 2010 17:48:44 +0800</pubDate><description><![CDATA[转自:
[http://hi.baidu.com/saint13/blog/item/e0705a959616b80e7bf4808f.html]


java.lang.OutOfMemoryError: Java heap space

用eclipse 开发，碰到java.lang.OutOfMemoryError: Java heap space异常

解决办法：

1...]]></description><category></category></item><item><title><![CDATA[sql 中使用参数]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81820854</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81820854</guid><author>iteye_13422</author><pubDate>Tue, 26 Jan 2010 17:04:28 +0800</pubDate><description><![CDATA[表格sql使用参数: 
参见http://www.cognoschina.net/club/thread-929-1-1.html
#prompt('参数名称', '参数类型')# .

#prompt( prompt_name , datatype , defaultText , text , queryItem , trailing_text )#
提示用户输入单个值。只需 prom...]]></description><category></category></item><item><title><![CDATA[Oracle10g的SQL正则表达式支持]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81819014</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81819014</guid><author>iteye_13422</author><pubDate>Tue, 19 Jan 2010 10:56:55 +0800</pubDate><description><![CDATA[[转自:http://database.51cto.com/art/200604/25127.htm]

Oracle 数据库目前内建了符合POSIX 标准的正则表达式。

四个新的函数分别是：REGEXP_LIKE、REGEXP_INSTR、REGEXP_SUBSTR、和 REGEXP_REPLACE。它们在用法上与Oracle SQL 函数LIKE、INSTR、SUBSTR 和REPL...]]></description><category></category></item><item><title><![CDATA[report studio 值提示]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81800232</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81800232</guid><author>iteye_13422</author><pubDate>Wed, 16 Dec 2009 15:22:51 +0800</pubDate><description><![CDATA[report studio 值提示

1.提示框默认项的显示名称的修改：

用三个html，前两个放在你的提示框(值提示)的两边。
第一个的内容是：，
第二个是，
这两个共同起作用，将提示框的ID赋值为TSKid。
第三个放在下面随便一个地方就行，用于将提示框的默认名称修改为指定值，代码是：

  //提示框的ID是&quot;TSKid&quot;
  var theSpan = docume...]]></description><category></category></item><item><title><![CDATA[sql运行效率查询(oracle)]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81767887</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81767887</guid><author>iteye_13422</author><pubDate>Sun, 27 Sep 2009 17:54:43 +0800</pubDate><description><![CDATA[SELECT EXECUTIONS,
       DISK_READS,
       BUFFER_GETS,
       ROUND((BUFFER_GETS - DISK_READS) / BUFFER_GETS, 2) Hit_radio,
       ROUND(DISK_READS / EXECUTIONS, 2) Reads_per_run,
       SQL_T...]]></description><category></category></item><item><title><![CDATA[查询表结构(oracle)]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81766877</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81766877</guid><author>iteye_13422</author><pubDate>Wed, 23 Sep 2009 17:18:08 +0800</pubDate><description><![CDATA[1.简略:
select * from ALL_TAB_COLS A
where lower(A.Table_Name) = 't_s_pd_invest_prod_no'

2.详细
select A.COLUMN_NAME,
       
       decode(A.DATA_TYPE,
              'CHAR',
              A.DAT...]]></description><category></category></item><item><title><![CDATA[窗体window大小设置]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81764883</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81764883</guid><author>iteye_13422</author><pubDate>Wed, 16 Sep 2009 11:23:01 +0800</pubDate><description><![CDATA[原文出处:http://chen-xiao-mei2009-163-com.iteye.com/blog/381922

网页可见区域宽：document.body.clientWidth 
网页可见区域高：document.body.clientHeight 
网页可见区域宽：document.body.offsetWidth (包括边线的宽) 
网页可见区域高：document.bo...]]></description><category></category></item><item><title><![CDATA[oracle if语句]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81719086</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81719086</guid><author>iteye_13422</author><pubDate>Thu, 07 May 2009 14:25:19 +0800</pubDate><description><![CDATA[oracle 的 if语句比较特殊,没有else if,而是使用elsif,使用方法如下:
if ... then
begin
...
end;
elsif ... then
begin
...
end;
else 
begin
...
end;
end if;]]></description><category></category></item><item><title><![CDATA[oracle 日期相关（连载中...）]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81716485</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81716485</guid><author>iteye_13422</author><pubDate>Fri, 24 Apr 2009 13:33:23 +0800</pubDate><description><![CDATA[1.下周周几为哪天：
取得下周周五日期：
select next_day(sysdate,6) from dual；

2.本周第一天（周日）：
select trunc(sysdate, 'D') from dual;

使用这个达到按周分组的目的
group by trunc(DATA_DATE, 'D');

3.本年的第几个星期：
select to_char(sys...]]></description><category></category></item><item><title><![CDATA[修改 sql server 排序规则]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81691986</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81691986</guid><author>iteye_13422</author><pubDate>Tue, 24 Mar 2009 17:49:49 +0800</pubDate><description><![CDATA[[转载]
sql排序规则 如果要是区分大小写的话，就要改变数据库的排序规则。 
1、查看系统中所支持的全部排序规则列表 SELECT * FROM ::fn_helpcollations() .
2、查看当前系统的排序规则. SELECT SERVERPROPERTY('Collation') 
3、改变数据库的排序规则(做ALTER之前,要中断所有用户对此数据库的访问) 
语法： us...]]></description><category></category></item><item><title><![CDATA[sql server 用户访问权限设置]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81691825</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81691825</guid><author>iteye_13422</author><pubDate>Tue, 24 Mar 2009 10:43:20 +0800</pubDate><description><![CDATA[[转载]
原文地址:http://topic.youkuaiyun.com/u/20080106/20/84b91329-d680-40a1-b09f-af601e83647d.html

sql server 用户访问权限设置:

/*--示例说明
        示例在数据库pubs中创建一个拥有表jobs的所有权限、拥有表titles的SELECT权限的角色r_test
    随后创建了...]]></description><category></category></item><item><title><![CDATA[窄表变宽表方式]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81691818</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81691818</guid><author>iteye_13422</author><pubDate>Tue, 24 Mar 2009 10:18:26 +0800</pubDate><description><![CDATA[1.使用decode,根据窄表某字段的值,来判断作为宽表的哪个字段.

2.使用union+group by.
每次取窄表的某一种值,作为宽表的一个字段,其他设为空,作为一个子表;
union连接各各字表;
group by 聚合;
...]]></description><category></category></item><item><title><![CDATA[oracle中java类的使用]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81691116</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81691116</guid><author>iteye_13422</author><pubDate>Fri, 20 Mar 2009 16:29:25 +0800</pubDate><description><![CDATA[java类创建:
create or replace and compile java source named test as
public class A
{
  public static String sayHello(String name){
         String ret = dealStr(name);
         return ret;
  }
  ...]]></description><category></category></item><item><title><![CDATA[资金流量指标MFI]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81689015</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81689015</guid><author>iteye_13422</author><pubDate>Wed, 11 Mar 2009 10:12:09 +0800</pubDate><description><![CDATA[MFI:资金流量指标
根据成交量来计测市场供需关系和买卖力道。该指标是通过反映股价变动的四个元素：上涨的天数、下跌的天数、成交量增加幅度、成交量减少幅度来研判量能的趋势，预测市场供求关系和买卖力道，属于量能反趋向指标。 

计算公式:
1.当日代表性价格（TP）＝(当日最高价+当日最低价+当日收盘价)/3。
2.资金流量（MF）＝TP×成交金额。 
2.分辨积极MF（PMF）及消极MF...]]></description><category></category></item><item><title><![CDATA[oracle函数整合]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81688845</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81688845</guid><author>iteye_13422</author><pubDate>Tue, 10 Mar 2009 16:18:55 +0800</pubDate><description><![CDATA[oracle函数:
1.方差VARIANCE

2.绝对值ABS

3.字符补全RPAD和LPAD
Rpad('AAA',10,'*'),AAA不够长度10,在AAA的右边用*补全.

4.大小写转换Lower和Upper

5.查找目标(indexOf)
INSTR(源字符串, 目标字符串, 起始位置, 匹配序号)
...]]></description><category></category></item><item><title><![CDATA[排序(oracle)]]></title><link>https://blog.youkuaiyun.com/iteye_13422/article/details/81688524</link><guid>https://blog.youkuaiyun.com/iteye_13422/article/details/81688524</guid><author>iteye_13422</author><pubDate>Mon, 09 Mar 2009 12:14:36 +0800</pubDate><description><![CDATA[根据INVT_PROD_ID和START_DT,按照ANN_DT 进行排序:
 select count(*) OVER(PARTITION BY A.INVT_PROD_ID, A.START_DT ORDER BY A.ANN_DT desc) as num,
        A.INVT_PROD_ID,
        A.START_DT,
        A.SCALE
  ...]]></description><category></category></item></channel></rss>