<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuimin1905的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuimin1905</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuimin1905]]></copyright><item><title><![CDATA[10g exp 9i数据得到问题]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338040</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338040</guid><author>cuimin1905</author><pubDate>Thu, 18 Nov 2010 16:09:02 +0800</pubDate><description><![CDATA[今天在帮同事导数据时遇到了如下的问题：
C:\Documents and Settings\JackolWu&gt;exp scott/tiger@orcl tables=emp,dept file=d:\a.dmp log=...]]></description><category></category></item><item><title><![CDATA[（转）drop truncate delete的区别]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338067</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338067</guid><author>cuimin1905</author><pubDate>Thu, 18 Nov 2010 11:24:14 +0800</pubDate><description><![CDATA[原文链接：http://www.cublog.cn/u3/93463/showart_1967550.html

相同之处：
1.truncate和不带where子句的delete、以及drop都会删除表内的数据...]]></description><category></category></item><item><title><![CDATA[学习data pump的一点记录]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338038</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338038</guid><author>cuimin1905</author><pubDate>Wed, 17 Nov 2010 11:17:32 +0800</pubDate><description><![CDATA[使用expdp工具导出数据时，由于转储文件只能存放在服务器上DIRECTORY对象对应的系统目录中，因此在使用之前必须先为用户授予CREATE ANY DIRECTORY 的权限，并且需要在服务器上建立DIREC...]]></description><category></category></item><item><title><![CDATA[（转）SQL语句的执行顺序]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338032</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338032</guid><author>cuimin1905</author><pubDate>Wed, 03 Nov 2010 11:01:16 +0800</pubDate><description><![CDATA[在编写SQL语句时，自己一直不了解SQL语句的执行顺序，今天上网查了下，看到一篇文章，觉得解释比较清楚，特此记录一下！
链接地址：SQL语句执行顺序
一、sql语句的执行步骤： 1）语法分析，分析语句的语法是...]]></description><category></category></item><item><title><![CDATA[（转）SQL中的left outer join,inner join,right outer join用法]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338033</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338033</guid><author>cuimin1905</author><pubDate>Wed, 21 Apr 2010 10:06:40 +0800</pubDate><description><![CDATA[原文出处：http://hi.baidu.com/llscompazz/blog/item/dc5e23d9ce2b62eb39012fb4.html/cmtid/357f71731c4615108601b056
使用关系代数...]]></description><category></category></item><item><title><![CDATA[(转)Oracle 排序中常用的NULL值处理方法]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338031</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338031</guid><author>cuimin1905</author><pubDate>Wed, 21 Apr 2010 09:41:21 +0800</pubDate><description><![CDATA[原文出处：Oracle 排序中常用的NULL值处理方法
1、缺省处理

Oracle在Order by 时缺省认为null是最大值，所以如果是ASC升序则排在最后，DESC降序则排在最前
2、使用nvl函数

n...]]></description><category></category></item><item><title><![CDATA[DBMS_JOB包]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338035</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338035</guid><author>cuimin1905</author><pubDate>Tue, 06 Apr 2010 14:18:32 +0800</pubDate><description><![CDATA[在对抽取数据的过程实现并行化时用到了DBMS_Job包的相关知识，在此做一记录。以下内容来源于网络。DBMS_Job包的用法
包含以下子过程： 
Broken()过程。change()过程。Interval()过程。Isub...]]></description><category></category></item><item><title><![CDATA[小心愚人节]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338029</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338029</guid><author>cuimin1905</author><pubDate>Thu, 01 Apr 2010 09:06:09 +0800</pubDate><description><![CDATA[今天是愚人节，要保持高度的警惕，千万别被愚！
                                                            
                    
         ...]]></description><category></category></item><item><title><![CDATA[优化器]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338063</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338063</guid><author>cuimin1905</author><pubDate>Mon, 29 Mar 2010 15:15:56 +0800</pubDate><description><![CDATA[optimizer_mode参数值Oracle 9iRBO (Rule Based Optimizer) 基于规则alter session set optimizer_mode = RULE;CBO (Cost Based O...]]></description><category></category></item><item><title><![CDATA[Oracle 启用OMF时遇到的问题]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338034</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338034</guid><author>cuimin1905</author><pubDate>Wed, 24 Mar 2010 12:13:10 +0800</pubDate><description><![CDATA[OS:RHEL5DB:SQL&gt; SELECT * FROM V$VERSION;
BANNER---------------------------------------------------------------...]]></description><category></category></item><item><title><![CDATA[启用oracle flashback时遇到的问题]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338030</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338030</guid><author>cuimin1905</author><pubDate>Tue, 23 Mar 2010 15:37:52 +0800</pubDate><description><![CDATA[OS:RHEL5DB:SQL&gt; SELECT * FROM V$VERSION;
BANNER---------------------------------------------------------------...]]></description><category></category></item><item><title><![CDATA[alter session\alter system\alter database]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338066</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338066</guid><author>cuimin1905</author><pubDate>Fri, 19 Mar 2010 15:22:02 +0800</pubDate><description><![CDATA[论坛里看到的，这三条语句的区别，做一记录。
alter database 改变的一个数据库的属性 一般改变的是物理上的能看得见的比如 ：alter dtabase rename datafilealter system...]]></description><category></category></item><item><title><![CDATA[XP下oracle的删除]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338062</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338062</guid><author>cuimin1905</author><pubDate>Thu, 18 Mar 2010 15:03:04 +0800</pubDate><description><![CDATA[今天有一新同事在XP下删除oracle10g后重新安装oracle9i时出现问题，发现是由于oracle10g的安装未删除干净造成的，故将很早之前在网上看到的删除oracle的步骤发上，做一备忘，此文档来源于网络，具体出处给忘记...]]></description><category></category></item><item><title><![CDATA[求助，被Oracle Concepts 整郁闷了！]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338028</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338028</guid><author>cuimin1905</author><pubDate>Thu, 18 Mar 2010 11:25:37 +0800</pubDate><description><![CDATA[大家能否介绍下都是怎么学习这个文档的呢？！由于自己的基础知识比较薄弱，自己在看的时候常常看的晕晕乎乎的，很多概念都不是很清楚！大家都是怎么去学习这个文档的呢？分享一下！小弟先谢谢了呀。
                     ...]]></description><category></category></item><item><title><![CDATA[放松&调整]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338027</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338027</guid><author>cuimin1905</author><pubDate>Mon, 15 Mar 2010 16:42:43 +0800</pubDate><description><![CDATA[近几天一直在看Oracle10g concepts，发现很多概念都无法理解，整的自己都头大了，来随便写写减压一下，呵呵。
通过几天的学习发现自己的基础知识特别贫瘠，还需要多多学习基础类的内容呀，等看完了这个文档，在复习复习数据...]]></description><category></category></item><item><title><![CDATA[学习Oracle起因& How Oracle Works]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338064</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338064</guid><author>cuimin1905</author><pubDate>Fri, 12 Mar 2010 16:02:54 +0800</pubDate><description><![CDATA[我之前一直做JAVA开发，平时对Oracle的接触就是基于Oracle的开发，也就是建建表，写写SQL和存储过程之类的，对Oracle的体系结构也不是很清楚，于是便想了解下相关方面的知识，近期在网上看了一些Oracle入门...]]></description><category></category></item><item><title><![CDATA[RHEL5安装Oracle10GR2]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338065</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338065</guid><author>cuimin1905</author><pubDate>Fri, 12 Mar 2010 12:11:38 +0800</pubDate><description><![CDATA[对博客相关文档的整理成TXT文本，以方便大家下载RHEL5安装Oracle10GR2.txt
                                                            
      ...]]></description><category></category></item><item><title><![CDATA[RHEL5安装Oracle10gR2]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338023</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338023</guid><author>cuimin1905</author><pubDate>Thu, 11 Mar 2010 17:01:34 +0800</pubDate><description><![CDATA[今天将自己动手在RHEL5U3上安装oracle10g的过程整理一下，在自己动手操作之前曾上网找了许多文档进行阅读和学习，整理的过程中结合其他人的文档和自己实际操作时遇到的问题。下面开始安装之旅了。一、安装需要的环境  ...]]></description><category></category></item><item><title><![CDATA[关于RHEL5U3安装oracle10gR2后,中文机登录EM乱码问题]]></title><link>https://blog.youkuaiyun.com/cuimin1905/article/details/100338024</link><guid>https://blog.youkuaiyun.com/cuimin1905/article/details/100338024</guid><author>cuimin1905</author><pubDate>Wed, 10 Mar 2010 10:00:51 +0800</pubDate><description><![CDATA[环境说明如下：OS：HOST OS: Windows XP SP3 VMware® Workstation 7.0.0 build-203739 GUEST OS :RHEL5U3 DB：Oracle Database 10...]]></description><category></category></item></channel></rss>