<?xml version="1.0" encoding="gbk"?>
<rss version="2.0">
  <channel>
    <title>Bo's Oracle Station - Oracle数据库开发</title>
    <link>https://www.botangdb.com/forum.php?mod=forumdisplay&amp;fid=39</link>
    <description>Latest 20 threads of Oracle数据库开发</description>
    <copyright>Copyright(C) Bo's Oracle Station</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Sun, 19 Apr 2026 04:20:57 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://www.botangdb.com/static/image/common/logo_88_31.gif</url>
      <title>Bo's Oracle Station</title>
      <link>https://www.botangdb.com/</link>
    </image>
    <item>
      <title>timestamp with local timezone和dbtimezone</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1471</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Tue, 13 Oct 2020 13:47:33 +0000</pubDate>
    </item>
    <item>
      <title>MERGE和关联删除和关联更新</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1470</link>
      <description><![CDATA[Merge是根据某个row source而有条件地选择性insert/delete/update目的表。但是它通过1次全表扫描（假设执行计划是全表扫描访问）就能够实现3次全表扫描才能完成的任务，因此提高了SQL执行的性能。由于它既然是insert/delete/update的合体，为了更清楚地了解原理，我们应 ...]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Tue, 13 Oct 2020 08:17:28 +0000</pubDate>
    </item>
    <item>
      <title>视图的约束</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1469</link>
      <description><![CDATA[SQL Error: ORA-01402: view WITH CHECK OPTION where-clause violation
01402. 00000 -  \&quot;view WITH CHECK OPTION where-clause violation\&quot;
*Cause:    
*Action:]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 11 Oct 2020 09:10:52 +0000</pubDate>
    </item>
    <item>
      <title>递归WITH</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1468</link>
      <description><![CDATA[A    B    1
C    D    2
B    C    3

A    B    1
C    D    2
B    C    1
A    C    2
B    D    3
A    D    4

把一张表看成两张表，
把WITH定义的当作第一张表，原表当作第2张表，
UNION ALL,
第一张表的第一个字段，第二张表的最后一个字段，
 ...]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 11 Oct 2020 08:36:18 +0000</pubDate>
    </item>
    <item>
      <title>关联子查询的组函数改写</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1467</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 27 Sep 2020 14:09:03 +0000</pubDate>
    </item>
    <item>
      <title>数据泵外部表（带并行度）</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1466</link>
      <description><![CDATA[导出：

导入：
orcl2:]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 27 Sep 2020 13:19:29 +0000</pubDate>
    </item>
    <item>
      <title>SQLLDR练习</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1465</link>
      <description><![CDATA[控制文件的语法：

希望缺项的行也被加载：

改完成后的控制文件：]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Thu, 24 Sep 2020 13:24:52 +0000</pubDate>
    </item>
    <item>
      <title>用ORACLE的查询语言来“解剖”数据字典</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1463</link>
      <description><![CDATA[select \&quot;SEQUENCE_ID\&quot;,\&quot;REASON_ID\&quot;,\&quot;OWNER\&quot;,\&quot;OBJECT_NAME\&quot;,\&quot;SUBOBJECT_NAME\&quot;,\&quot;OBJECT_TYPE\&quot;,\&quot;REASON\&quot;,\&quot;TIME_SUGGESTED\&quot;,\&quot;CREATION_TIME\&quot;,\&quot;SUGGESTED_ACTION\&quot;,\&quot;ADVISOR_NAME\&quot;,\&quot;METRIC_VALUE\&quot;,\&quot;MESSAGE_TYPE\&quot;,\&quot;MESSAGE_GROUP\&quot;,\&quot;MESSAGE_LEVEL\&quot;,\]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 20 Sep 2020 08:58:44 +0000</pubDate>
    </item>
    <item>
      <title>SHELL和SQL Script</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1462</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 20 Sep 2020 08:39:34 +0000</pubDate>
    </item>
    <item>
      <title>时间函数</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1461</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 20 Sep 2020 07:46:45 +0000</pubDate>
    </item>
    <item>
      <title>ORACLE与非结构化数据</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1460</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 20 Sep 2020 07:05:10 +0000</pubDate>
    </item>
    <item>
      <title>SQL性能分析</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1459</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Thu, 17 Sep 2020 12:17:52 +0000</pubDate>
    </item>
    <item>
      <title>集操作符要拼凑字段列表：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1457</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 13 Sep 2020 13:38:45 +0000</pubDate>
    </item>
    <item>
      <title>关联子查询如果可能把它改成普通子查询：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1456</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 13 Sep 2020 13:14:57 +0000</pubDate>
    </item>
    <item>
      <title>关联子查询都可以改写成两表连接，普通子查询和关联子查询可以放在任何地方：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1455</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 13 Sep 2020 12:45:41 +0000</pubDate>
    </item>
    <item>
      <title>成对比较（限定更强）和不成对比较：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1454</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 13 Sep 2020 12:37:53 +0000</pubDate>
    </item>
    <item>
      <title>分步骤的3表外连接：查询所有员工的工作城市</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1453</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Sun, 13 Sep 2020 08:57:33 +0000</pubDate>
    </item>
    <item>
      <title>decode的一些用法和AVG空值问题：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1452</link>
      <description><![CDATA[以下两个计算平均提成，错误的例子:]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Thu, 10 Sep 2020 12:48:50 +0000</pubDate>
    </item>
    <item>
      <title>日期和间隔：</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1451</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Tue, 08 Sep 2020 13:35:41 +0000</pubDate>
    </item>
    <item>
      <title>关于等级查询和lpad:</title>
      <link>https://www.botangdb.com/forum.php?mod=viewthread&amp;tid=1450</link>
      <description><![CDATA[]]></description>
      <category>Oracle数据库开发</category>
      <author>botang</author>
      <pubDate>Tue, 08 Sep 2020 12:31:53 +0000</pubDate>
    </item>
  </channel>
</rss>