<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[zhaogui_2的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zhaogui_2</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zhaogui_2]]></copyright><item><title><![CDATA[oracle数据库 序列实际值超前处理]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/147893876</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/147893876</guid><author>zhaogui_2</author><pubDate>Mon, 12 May 2025 12:21:15 +0800</pubDate><description><![CDATA[- 假设返回值为1000。-- 禁用缓存，避免预分配导致跳跃。START WITH 1001     -- 比表中最大值大1。-- 3. 创建新序列，起始值比表中最大值大1。-- 2. 重置序列（需要先删除再重建）-- 1. 获取表中pkey的最大值。]]></description><category></category></item><item><title><![CDATA[oracle财务报表Report Builder报错：错误 49 错误的赋值变量]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/145993312</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/145993312</guid><author>zhaogui_2</author><pubDate>Mon, 03 Mar 2025 17:04:33 +0800</pubDate><description><![CDATA[我是在编译报表的时候，在前报表编译时报错误的赋值变量，找不到：P_COST_CENTER。找到报表下面的用户参数，是否存在报错的那个，没有的话手动建一个，再编译就可以了。]]></description><category></category></item><item><title><![CDATA[oracle 插入或更新带有转义字符“&“的值]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/137586194</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/137586194</guid><author>zhaogui_2</author><pubDate>Wed, 10 Apr 2024 10:19:39 +0800</pubDate><description><![CDATA[SQL语句中出现，替换为 【'||chr(38)||'】]]></description><category></category></item><item><title><![CDATA[oracle 修改序列步长]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/137585946</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/137585946</guid><author>zhaogui_2</author><pubDate>Wed, 10 Apr 2024 10:16:15 +0800</pubDate><description><![CDATA[【代码】oracle 修改序列步长。]]></description><category></category></item><item><title><![CDATA[邮箱正则校验邮箱账号是否合法]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/133702884</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/133702884</guid><author>zhaogui_2</author><pubDate>Mon, 09 Oct 2023 15:36:22 +0800</pubDate><description><![CDATA[邮箱正则校验邮箱账号是否合法Java代码]]></description><category></category></item><item><title><![CDATA[Oracle decode函数使用]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127106962</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127106962</guid><author>zhaogui_2</author><pubDate>Mon, 09 Oct 2023 15:02:00 +0800</pubDate><description><![CDATA[decode函数指定排序、比较值]]></description><category></category></item><item><title><![CDATA[使用merge 报错 ORA-30926 无法在源表中获得一组稳定的行]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/133698904</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/133698904</guid><author>zhaogui_2</author><pubDate>Mon, 09 Oct 2023 14:57:23 +0800</pubDate><description><![CDATA[使用merge 报错 ORA-30926 无法在源表中获得一组稳定的行]]></description><category></category></item><item><title><![CDATA[ORACLE 简单存储过程]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/133125423</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/133125423</guid><author>zhaogui_2</author><pubDate>Thu, 21 Sep 2023 10:06:59 +0800</pubDate><description><![CDATA[实现每日同步一个表的数据至另一个表。]]></description><category></category></item><item><title><![CDATA[ORACLE JOB 定时任务]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/133124671</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/133124671</guid><author>zhaogui_2</author><pubDate>Thu, 21 Sep 2023 10:03:17 +0800</pubDate><description><![CDATA[ORACLE JOB 定时任务 每日一点执行同步]]></description><category></category></item><item><title><![CDATA[String类型字段为空情况下，判空报错]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127903217</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127903217</guid><author>zhaogui_2</author><pubDate>Thu, 17 Nov 2022 14:26:57 +0800</pubDate><description><![CDATA[在对一个字段进行if判断的时候，用.isEmpty()方法，控制台报错null]]></description><category></category></item><item><title><![CDATA[Oracle 带有特殊符号的别名（如：/ , - 等）]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127571047</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127571047</guid><author>zhaogui_2</author><pubDate>Fri, 28 Oct 2022 14:28:48 +0800</pubDate><description><![CDATA[碰到个问题，字段别名要显示"直接/间接"，在代码里面直接会报错。]]></description><category></category></item><item><title><![CDATA[Oracle给查询结果添加序列号（存在order by）]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127569195</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127569195</guid><author>zhaogui_2</author><pubDate>Fri, 28 Oct 2022 12:20:01 +0800</pubDate><description><![CDATA[遇到个问题，使用rownum给查询结果增加序号，再使用order by排序后，查询结果的序列号乱了，经查找，修改SQL如下。]]></description><category></category></item><item><title><![CDATA[Jfinal框架SQL模板中使用TO_DATE函数出错]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127515209</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127515209</guid><author>zhaogui_2</author><pubDate>Tue, 25 Oct 2022 16:01:04 +0800</pubDate><description><![CDATA[Jfinal框架SQL模板中使用TO_DATE函数出错]]></description><category></category></item><item><title><![CDATA[Oracle生成连续数据]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107697</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107697</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 15:27:54 +0800</pubDate><description><![CDATA[Oracle生成数据]]></description><category></category></item><item><title><![CDATA[SQL中union和union all的用法]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107413</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107413</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 15:16:56 +0800</pubDate><description><![CDATA[SQL中union和union all的用法]]></description><category></category></item><item><title><![CDATA[Oracle中使用nvl函数有值却一直返回0的问题]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107131</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127107131</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 15:08:52 +0800</pubDate><description><![CDATA[Oracle中使用nvl函数有值却一直返回0的问题]]></description><category></category></item><item><title><![CDATA[Java字符串转日期或日期转字符串]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127105472</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127105472</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 13:57:55 +0800</pubDate><description><![CDATA[SimpleDateFormat字符串转日期]]></description><category></category></item><item><title><![CDATA[Ant design-vue的a-table表格缺少rowkey，标识不唯一]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127104598</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127104598</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 12:25:52 +0800</pubDate><description><![CDATA[Ant Design Vue 的rowKey不唯一]]></description><category></category></item><item><title><![CDATA[JFinal框架时间相关的使用]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127104384</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127104384</guid><author>zhaogui_2</author><pubDate>Thu, 29 Sep 2022 11:59:23 +0800</pubDate><description><![CDATA[JFinal框架时间相关的]]></description><category></category></item><item><title><![CDATA[Oracle获取第二天早上五点半的时间]]></title><link>https://blog.youkuaiyun.com/zhaogui_2/article/details/127089358</link><guid>https://blog.youkuaiyun.com/zhaogui_2/article/details/127089358</guid><author>zhaogui_2</author><pubDate>Wed, 28 Sep 2022 14:57:20 +0800</pubDate><description><![CDATA[Oracle获取第二天早上五点半的时间]]></description><category></category></item></channel></rss>