<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wuyule002的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wuyule002</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wuyule002]]></copyright><item><title><![CDATA[ORA-01031: 权限不足 EXECUTE IMMEDIATE]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/134425126</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/134425126</guid><author>wuyule002</author><pubDate>Wed, 15 Nov 2023 17:26:17 +0800</pubDate><description><![CDATA[原因：CREATE TABLE想使用CREATE ANY TABLE权限，而CREATE ANY TABLE权限来自DBA角色，默认情况下，虽然在会话环境中可见，但在存储过程中不可见（无效）。在oracle存储过程中，默认是可以直接执行DML和DQL的，但是执行CREATE这种的DDL则需要借助EXECUTE IMMEDIATE ···了，如下备份表语句。即：ORACLE默认为定义者权限，定义者权限在存储过程中ROLE无效，需要显式授权。当执行该语句时，提示 ORA-01031: 权限不足。]]></description><category></category></item><item><title><![CDATA[index 索引查询]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/134240567</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/134240567</guid><author>wuyule002</author><pubDate>Mon, 06 Nov 2023 10:19:26 +0800</pubDate><description><![CDATA[seleindexesct * from all_indexes t where t.index_name like 'INDEX_YK_%']]></description><category></category></item><item><title><![CDATA[oracle 建立索引语句]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/134240100</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/134240100</guid><author>wuyule002</author><pubDate>Mon, 06 Nov 2023 10:02:50 +0800</pubDate><description><![CDATA[create index IDXLPSMSTPS04 on LPS_MST (open_date)]]></description><category></category></item><item><title><![CDATA[手动停止oracle DBMS_Job]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/134186153</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/134186153</guid><author>wuyule002</author><pubDate>Thu, 02 Nov 2023 16:42:36 +0800</pubDate><description><![CDATA[next_date：（某一时刻停止），也可是sysdate（立刻停止）(默认值为sysdate)。格式：dbms_job.broken(jobId,broken,next_date);broken：值为true时，表示禁用job;值为false时，表示启用job。jobId：定时任务的编号（DBMS_Job）--手动停止某个DBMS_Job。]]></description><category></category></item><item><title><![CDATA[oracle创建DBMS_Jobs]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/134177741</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/134177741</guid><author>wuyule002</author><pubDate>Thu, 02 Nov 2023 11:03:06 +0800</pubDate><description><![CDATA[',  /*需执行的存储过程名称或SQL语句*/INTERVAL => 'sysdate+1/5440' /*执行间隔（每隔5分钟执行）*/NEXT_DATE => sysdate,  /*初次执行时间（立即执行）*/JOB => job,  /*自动生成JOB_ID*/--通过SQL创建DBMS_Jobs（模板）]]></description><category></category></item><item><title><![CDATA[oracle插入数据前判断表中是否存储重复数据]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/132078487</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/132078487</guid><author>wuyule002</author><pubDate>Thu, 03 Aug 2023 10:44:28 +0800</pubDate><description><![CDATA[这样，当数据库里有一个id='111'的记录的时候，就不会进行insert操作了。有时候用oracle的数据库，插入数据的时候需要判断一下该条数据是否已经存在。然后判断isExists等于0与否，如果等于0，则执行insert。上面这样写，也可以，但是多写很多代码，不利于后期维护。]]></description><category></category></item><item><title><![CDATA[博客摘录「 Merge into的用法」2023年8月3日]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/132077996</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/132077996</guid><author>wuyule002</author><pubDate>Thu, 03 Aug 2023 10:30:30 +0800</pubDate><description><![CDATA[总结：将表1中相同id的name属性更新成表2的name值，大概意思是基于table2，对于table1进行操作，当条件满足时，进行操作 1，不满足时就尽心操作2.并且将表1中没有而表2中有的数据添加到表1中。]]></description><category></category></item><item><title><![CDATA[mysql下 更改自增主键的值]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/127610230</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/127610230</guid><author>wuyule002</author><pubDate>Mon, 31 Oct 2022 10:12:29 +0800</pubDate><description><![CDATA[从10000开始，即实现自增主键的种子为10000。
使用alter table tablename  AUTO_INCREMENT=10000]]></description><category></category></item><item><title><![CDATA[activeMQ.producer 简单示例demo]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/124397749</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/124397749</guid><author>wuyule002</author><pubDate>Mon, 25 Apr 2022 09:41:49 +0800</pubDate><description><![CDATA[activeMQ.producer 简单示例demo]]></description><category></category></item><item><title><![CDATA[activeMQ.producer消息生产者,调整消息预读取条数1]]></title><link>https://blog.youkuaiyun.com/wuyule002/article/details/124397609</link><guid>https://blog.youkuaiyun.com/wuyule002/article/details/124397609</guid><author>wuyule002</author><pubDate>Mon, 25 Apr 2022 09:36:54 +0800</pubDate><description><![CDATA[activeMQ.producer消息生产者,调整消息预读取条数1]]></description><category></category></item></channel></rss>