<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ciscgs80864的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ciscgs80864</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ciscgs80864]]></copyright><item><title><![CDATA[Datastage数据库连接串配置]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352777</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352777</guid><author>ciscgs80864</author><pubDate>Fri, 01 Apr 2016 11:13:07 +0800</pubDate><description><![CDATA[Datastage数据库连接串配置： Oracle


一、进入DataStage后台Oracle客户端安装目录：

命令： cd $ORACLE_HOME（以实际安装目录为准）。
     cd net...]]></description><category></category></item><item><title><![CDATA[数据库优化]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352774</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352774</guid><author>ciscgs80864</author><pubDate>Wed, 30 Mar 2016 20:41:42 +0800</pubDate><description><![CDATA[1、1、调整数据结构的设计。这一部分在开发信息系统之前完成，程序员需要考虑是否使用ORACLE数据库的分区功能，对于经常访问的数据库表是否需要建立索引等。

2、2、调整应用程序结构设计。这一部分也是在开发信息系统之前完成...]]></description><category></category></item><item><title><![CDATA[Greenplum数据库常用游标写法]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352778</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352778</guid><author>ciscgs80864</author><pubDate>Tue, 29 Mar 2016 08:32:41 +0800</pubDate><description><![CDATA[一、明码游标
Create or replace function funcion_name (param1,param2)  ---一般定义存储过程中使用游标去循环调用另一个过程
retuen integer as...]]></description><category></category></item><item><title><![CDATA[SQL性能调整工具explain plan,set autotrace,10046之间有什么区别]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352775</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352775</guid><author>ciscgs80864</author><pubDate>Wed, 09 Mar 2016 09:35:19 +0800</pubDate><description><![CDATA[(1)、explain plan并没有真正执行目标SQL，优化器通过收据数据字典等信息，给出的执行计划。所以，得到的执行计划可能是不准的，即与实际的执行计划有偏差。
(2)、set autotrace 虽然实际执行了目标SQL...]]></description><category></category></item><item><title><![CDATA[数据仓库拥有的四个特点]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352773</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352773</guid><author>ciscgs80864</author><pubDate>Mon, 22 Feb 2016 16:10:37 +0800</pubDate><description><![CDATA[原文：http://blog.sina.com.cn/s/blog_4968aebf0100kuuk.html
    http://blog.youkuaiyun.com/chenrizhong/article/det...]]></description><category></category></item><item><title><![CDATA[Oracle安装过程中出现ORA-12560：TNS：协议适配器错误]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352771</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352771</guid><author>ciscgs80864</author><pubDate>Tue, 19 Jan 2016 09:06:22 +0800</pubDate><description><![CDATA[出现ORA-12560: TNS: 协议适配器错误的问题主要有一下原因：

 1.当Oracle实例的服务没有启动。

在运行窗口输入services.msc回车。
找到当前Oracle数据库实例的服务，并启动o...]]></description><category></category></item><item><title><![CDATA[在SQL语句中用PARALLEL指定并行查询]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352770</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352770</guid><author>ciscgs80864</author><pubDate>Wed, 16 Dec 2015 15:26:33 +0800</pubDate><description><![CDATA[在日常查询中为提供SQL的查询速度，常用到parallel 关键字执行并行查询。

1.第一种对下面的SQL对xt.test1用并行怎么写 ？
2.第二种对下面的SQL对2张表都用并行怎么写？
 selectcoun...]]></description><category></category></item><item><title><![CDATA[Oracle 11g 的新特性- 组合触发器 (Compound Triggers)]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352769</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352769</guid><author>ciscgs80864</author><pubDate>Fri, 04 Dec 2015 14:33:54 +0800</pubDate><description><![CDATA[原文出处:http://www.oschina.net/question/12_62292

在以前版本的 Oracle 中，你可通过 FOLLOWS 关键字来控制触发器执行的顺序，例如：


	
		
	...]]></description><category></category></item><item><title><![CDATA[Orace自定义“周”的开始和结束时间]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352772</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352772</guid><author>ciscgs80864</author><pubDate>Fri, 04 Dec 2015 10:33:21 +0800</pubDate><description><![CDATA[日常学习小知识记录。

原文出处：http://www.itpub.net/thread-1944374-1-1.html

一、业务需求

业务上规定本周五到下周四为一个“周”，需求是任意给出一段时间，比如2015...]]></description><category></category></item><item><title><![CDATA[Oracle变量的定义、赋值及使用]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352823</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352823</guid><author>ciscgs80864</author><pubDate>Fri, 04 Dec 2015 10:04:27 +0800</pubDate><description><![CDATA[Oracle变量的定义、赋值及使用:


	
		
			点击(此处)折叠或打开
		
	
	
		
			
				declare
 
			
			
				l_dept intege...]]></description><category></category></item><item><title><![CDATA[Oracle分析函数Lead()，Lag()]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352767</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352767</guid><author>ciscgs80864</author><pubDate>Thu, 03 Dec 2015 09:39:35 +0800</pubDate><description><![CDATA[其实这2个函数的作用非常好理解，Lead()就是取当前顺序的下一条记录，相对Lag()就是取当前顺序的上一行记录。


	经常会有判断在一定条件下的两条记录之间的时间差这样的需求。


	Lead()函数的用法...]]></description><category></category></item><item><title><![CDATA[oracle中的savepoints是什么]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352766</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352766</guid><author>ciscgs80864</author><pubDate>Tue, 01 Dec 2015 09:01:36 +0800</pubDate><description><![CDATA[给你个例子
SQL&gt; create table test (id number(7));

表已创建。

SQL&gt; insert into test values (3);

已创建 1 行。

S...]]></description><category></category></item><item><title><![CDATA[Datastage中Sequential file和Data Set、File Set三者之间的区别]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352768</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352768</guid><author>ciscgs80864</author><pubDate>Mon, 23 Nov 2015 17:31:15 +0800</pubDate><description><![CDATA[在DS中有三种我们常用到的数据文件类型：Sequential file和Data Set、File Set

一、Sequential file

  定长和非定长文件字符文件。
 1、用于读文件和写文...]]></description><category></category></item><item><title><![CDATA[Oracle同时多表插入insert first&insert all的区别]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352763</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352763</guid><author>ciscgs80864</author><pubDate>Fri, 20 Nov 2015 17:12:10 +0800</pubDate><description><![CDATA[原文：
http://lanying1982.blog.163.com/blog/static/23067748200810122341539/

insert first/all


	利用in...]]></description><category></category></item><item><title><![CDATA[Oracle当有数据写入时将max分区拆分是否会导致异常]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352765</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352765</guid><author>ciscgs80864</author><pubDate>Fri, 20 Nov 2015 16:58:03 +0800</pubDate><description><![CDATA[原文：
http://zhidao.baidu.com/link?url=WDmPISaSZGZ5M8Dci_lmsLgl531wkzG7GcDcTW3fjD3EXJBEq_tdu12zyC7uWKFxBsIW9SLbhpoC...]]></description><category></category></item><item><title><![CDATA[Oracle中的异常处理]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352762</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352762</guid><author>ciscgs80864</author><pubDate>Tue, 10 Nov 2015 13:56:13 +0800</pubDate><description><![CDATA[异常处理是Oracle中必不可少的部分。

	
		
	
	
		
			
				点击(此处)折叠或打开
			
		
		
			
				
					begin
 
				
				
...]]></description><category></category></item><item><title><![CDATA[Oracle中的NO_DATA_FOUND系统变量]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352764</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352764</guid><author>ciscgs80864</author><pubDate>Tue, 10 Nov 2015 11:26:24 +0800</pubDate><description><![CDATA[一、过程中NO_DATA_FOUND的用法：


	1.首先创建一个表lengzijiantest，表中只有一个字段f_id


	
		
			
				
			
		
	


	
		
		...]]></description><category></category></item><item><title><![CDATA[ORA-00054 的解决方法]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352759</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352759</guid><author>ciscgs80864</author><pubDate>Tue, 03 Nov 2015 17:18:19 +0800</pubDate><description><![CDATA[在删除系统有一个不用的索引时，出现了ORA-00054错误。


	SQL&gt; drop index GPSTIME_GLOBAL_INDEX
2/

drop index GPSTIME_GL...]]></description><category></category></item><item><title><![CDATA[Oracle安装系统和网络检查不通过的问题和解决方法]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352761</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352761</guid><author>ciscgs80864</author><pubDate>Sat, 31 Oct 2015 14:54:34 +0800</pubDate><description><![CDATA[检查日志描述(仅显示了未通过的部分日志)： 


	
		
			点击(此处)折叠或打开
		
	
	
		
			
				正在检查操作系统要求...
			
			
				
			
	...]]></description><category></category></item><item><title><![CDATA[SQL中PIVOT 行列转换]]></title><link>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352760</link><guid>https://blog.youkuaiyun.com/ciscgs80864/article/details/100352760</guid><author>ciscgs80864</author><pubDate>Sat, 31 Oct 2015 14:47:38 +0800</pubDate><description><![CDATA[本文转载处：http://www.studyofnet.com/news/295.html

	本文导读：T-SQL语句中，Pivot运算符用于在列和行之间对数据进行旋转或透视转换，PIVOT命令可以实现数据表的列转行，同时...]]></description><category></category></item></channel></rss>