<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[songcode的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/songcode</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; songcode]]></copyright><item><title><![CDATA[Java通过Cloud Sql Proxy连接GCP上的Postgres SQL]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/145655294</link><guid>https://blog.youkuaiyun.com/songcode/article/details/145655294</guid><author>songcode</author><pubDate>Sat, 15 Feb 2025 19:32:11 +0800</pubDate><description><![CDATA[代码有空了更新到这里。]]></description><category></category></item><item><title><![CDATA[Oracle index]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/137053442</link><guid>https://blog.youkuaiyun.com/songcode/article/details/137053442</guid><author>songcode</author><pubDate>Tue, 26 Mar 2024 17:59:28 +0800</pubDate><description><![CDATA[alter index indexname rebuild；]]></description><category></category></item><item><title><![CDATA[VS Code插件Kafka连接]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/136741341</link><guid>https://blog.youkuaiyun.com/songcode/article/details/136741341</guid><author>songcode</author><pubDate>Fri, 15 Mar 2024 15:32:18 +0800</pubDate><description><![CDATA[NameSSLclient key。]]></description><category></category></item><item><title><![CDATA[Oracle 一些有用的表]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/135246565</link><guid>https://blog.youkuaiyun.com/songcode/article/details/135246565</guid><author>songcode</author><pubDate>Wed, 27 Dec 2023 15:07:39 +0800</pubDate><description><![CDATA[查询那些对象引用了某字段。]]></description><category></category></item><item><title><![CDATA[读懂Oracle SQL执行计划]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/132544613</link><guid>https://blog.youkuaiyun.com/songcode/article/details/132544613</guid><author>songcode</author><pubDate>Tue, 26 Sep 2023 11:57:24 +0800</pubDate><description><![CDATA[Access Path访问路径分析：访问数据是用TableScan还是index(FastFullScan)对返回的行结果集做例如Join/filter/excludes的进一步处理，以便返回行给客户端。不实际执行SQL语句，生成的计划未必是真实的执行计划。Sql语句的执行最终会落实为Oracle执行步骤的组合 = 》 sql执行计划。必须要有plan_table。4 V$SQL和V$SQL_PLAN。2 怎么查看执行计划。3 怎么读懂执行计划。]]></description><category></category></item><item><title><![CDATA[Oracle error code]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/132892189</link><guid>https://blog.youkuaiyun.com/songcode/article/details/132892189</guid><author>songcode</author><pubDate>Thu, 14 Sep 2023 22:41:10 +0800</pubDate><description><![CDATA[应该提前考虑到执行操作时，表有无锁。尽量选择没人用的时候去做。收纳下自己遇到过的error code。]]></description><category></category></item><item><title><![CDATA[Oracle hints 优化器]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/130639211</link><guid>https://blog.youkuaiyun.com/songcode/article/details/130639211</guid><author>songcode</author><pubDate>Fri, 12 May 2023 11:44:26 +0800</pubDate><description><![CDATA[table Access full 全表扫码。nested loop嵌套循环。]]></description><category></category></item><item><title><![CDATA[Oracle 闪回查询]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/130416756</link><guid>https://blog.youkuaiyun.com/songcode/article/details/130416756</guid><author>songcode</author><pubDate>Thu, 27 Apr 2023 22:43:47 +0800</pubDate><description><![CDATA[晚点更新内容。]]></description><category></category></item><item><title><![CDATA[Oracle SQL查询慢 Hints 指定索引]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/129817957</link><guid>https://blog.youkuaiyun.com/songcode/article/details/129817957</guid><author>songcode</author><pubDate>Tue, 28 Mar 2023 15:51:34 +0800</pubDate><description><![CDATA[这个indexname要是真的这个条件a建的索引。]]></description><category></category></item><item><title><![CDATA[SQL的书写顺序]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/128354994</link><guid>https://blog.youkuaiyun.com/songcode/article/details/128354994</guid><author>songcode</author><pubDate>Sat, 17 Dec 2022 16:58:14 +0800</pubDate><description><![CDATA[Select

From

Where

Group by

Having

Order by
]]></description><category></category></item><item><title><![CDATA[QlikSense使用]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/127208560</link><guid>https://blog.youkuaiyun.com/songcode/article/details/127208560</guid><author>songcode</author><pubDate>Sat, 08 Oct 2022 14:41:05 +0800</pubDate><description><![CDATA[持续更新中
]]></description><category></category></item><item><title><![CDATA[Miss HSTS header in checkmarx]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/126683931</link><guid>https://blog.youkuaiyun.com/songcode/article/details/126683931</guid><author>songcode</author><pubDate>Sat, 03 Sep 2022 23:04:47 +0800</pubDate><description><![CDATA[按照Owasp的推荐设置 header 后依然无法通过checkmarx SAST scan.无奈只能acknowledge.

后续更新细节。
]]></description><category></category></item><item><title><![CDATA[Oracle SQL 如何重复执行？]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/125337642</link><guid>https://blog.youkuaiyun.com/songcode/article/details/125337642</guid><author>songcode</author><pubDate>Fri, 17 Jun 2022 17:35:05 +0800</pubDate><description><![CDATA[SQL 重复执行]]></description><category></category></item><item><title><![CDATA[多表关联，如何解决结果集重复问题]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/124762102</link><guid>https://blog.youkuaiyun.com/songcode/article/details/124762102</guid><author>songcode</author><pubDate>Sat, 11 Jun 2022 15:09:42 +0800</pubDate><description><![CDATA[Select * from AA a

left join BB b on a.a = b.b

left join CC c on c.c = b.c and a.d = c.d
]]></description><category></category></item><item><title><![CDATA[Oracle 存储过程 问题记录]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/123945916</link><guid>https://blog.youkuaiyun.com/songcode/article/details/123945916</guid><author>songcode</author><pubDate>Sun, 03 Apr 2022 22:15:59 +0800</pubDate><description><![CDATA[PLS-00103 End not pragma final instantiable order overriding static member constructor

一般就是格式问题比如 elsif 写成 else if

PLS-00306 wrong number or types of arguments in call to 'Procedure Name'

参数个数或者类型不匹配



重新编译存储过程

alter procedure procedure_name compile；.]]></description><category></category></item><item><title><![CDATA[Intellij IDEA 快捷键]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/123254074</link><guid>https://blog.youkuaiyun.com/songcode/article/details/123254074</guid><author>songcode</author><pubDate>Thu, 03 Mar 2022 14:48:50 +0800</pubDate><description><![CDATA[切换大小写 ctrl+ shift+ U
]]></description><category></category></item><item><title><![CDATA[Git | 如何恢复修改 | git stash pop]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/122647993</link><guid>https://blog.youkuaiyun.com/songcode/article/details/122647993</guid><author>songcode</author><pubDate>Tue, 15 Feb 2022 15:48:41 +0800</pubDate><description><![CDATA[git stash 将为提交的改动保存到堆栈中。

git stash pop 将堆栈中的改动弹出到当前分支


]]></description><category></category></item><item><title><![CDATA[Git | 如何丢弃当前修改]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/121044710</link><guid>https://blog.youkuaiyun.com/songcode/article/details/121044710</guid><author>songcode</author><pubDate>Sun, 23 Jan 2022 10:20:04 +0800</pubDate><description><![CDATA[git checkout . #本地所有的修改，没有提交的，都返回到原来的状态

git stash #把所有没有提交的修改暂存到stash里面。可用git stash pop恢复。

git reset --hard HASH #返回到某个节点，不保留修改。

git reset --soft HASH #返回到某个节点，保留修改。 git log #可以查看 git commit 的历史记录及其 HASH ID





git reset --soft HASH #返回到某个节点, 保留修改，已有..]]></description><category></category></item><item><title><![CDATA[怎样判断Jar是不是Runnable的]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/122569381</link><guid>https://blog.youkuaiyun.com/songcode/article/details/122569381</guid><author>songcode</author><pubDate>Tue, 18 Jan 2022 21:44:04 +0800</pubDate><description><![CDATA[需要查看META-INF/MANIFEST.MF里有没有
Main-Class: com.mypackage.MyClass

]]></description><category></category></item><item><title><![CDATA[ORA-01789 query block has incorrect number of result columns]]></title><link>https://blog.youkuaiyun.com/songcode/article/details/122474064</link><guid>https://blog.youkuaiyun.com/songcode/article/details/122474064</guid><author>songcode</author><pubDate>Thu, 13 Jan 2022 14:58:30 +0800</pubDate><description><![CDATA[Union语句字段数量不一致。

]]></description><category></category></item></channel></rss>