<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[debug2000的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/debug2000</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; debug2000]]></copyright><item><title><![CDATA[两个经典的Oracle触发器示例 .]]></title><link>https://blog.csdn.net/debug2000/article/details/46812927</link><guid>https://blog.csdn.net/debug2000/article/details/46812927</guid><author>debug2000</author><pubDate>Thu, 09 Jul 2015 10:00:14 +0800</pubDate><description><![CDATA[【案例一】
题目：
--触发器：
--添加员工信息,流水号作为自动编号(通过序列生成),
--并且判断如果工资小于0,则改为0;如果大于10000,则改为10000。
CREATE TABLE emp2(
e_id NUMBER,
e_no NUMBER,
e_name VARCHAR2(20),
e_sal NUMBER
)
SELECT * FROM emp2;
CRE]]></description><category></category></item><item><title><![CDATA[expdp/impdp 详细参数解释]]></title><link>https://blog.csdn.net/debug2000/article/details/8147275</link><guid>https://blog.csdn.net/debug2000/article/details/8147275</guid><author>debug2000</author><pubDate>Mon, 05 Nov 2012 08:06:17 +0800</pubDate><description><![CDATA[数据泵导出实用程序提供了一种用于在 Oracle 数据库之间传输
数据对象的机制。该实用程序可以使用以下命令进行调用:
   示例: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
您可以控制导出的运行方式。具体方法是: 在 'expdp' 命令后输入
各种参数。要指定各参数, 请使用关键字:
   格式:  expdp KEY]]></description><category></category></item><item><title><![CDATA[ORA-02030 WHEN GRANTING SELECT ON V$ VIEW]]></title><link>https://blog.csdn.net/debug2000/article/details/8147273</link><guid>https://blog.csdn.net/debug2000/article/details/8147273</guid><author>debug2000</author><pubDate>Mon, 05 Nov 2012 08:04:27 +0800</pubDate><description><![CDATA[When you grant v$session on select  to normal user,you will receive:ORA-02030: can only select from fixed tables/views
e.g.
    SQL> connsys/oracle@devdb1as
 sysdba
    Connected.
     SQL> creat]]></description><category></category></item><item><title><![CDATA[ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled]]></title><link>https://blog.csdn.net/debug2000/article/details/8147270</link><guid>https://blog.csdn.net/debug2000/article/details/8147270</guid><author>debug2000</author><pubDate>Mon, 05 Nov 2012 08:02:28 +0800</pubDate><description><![CDATA[ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Example:

In the example below the error Occurred while performing an open resetlogs on a 10.2.0.3 Oracle Single Inst]]></description><category></category></item></channel></rss>