<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[samLin2018的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/samLin2018</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; samLin2018]]></copyright><item><title><![CDATA[tns：无监听 解决之一：由于 linstener.log 贮存过满导致]]></title><link>https://blog.youkuaiyun.com/samLin2018/article/details/87187013</link><guid>https://blog.youkuaiyun.com/samLin2018/article/details/87187013</guid><author>samLin2018</author><pubDate>Wed, 13 Feb 2019 16:07:21 +0800</pubDate><description><![CDATA[ linstener.log ：超过4g就满了 导致功能出现问题

 

 

解决 ：

1.cmd--&amp;gt;lsnrctl --&amp;gt;set log_status off   

2.备份listener.log 

3.删除listener.log

4.cmd--&amp;gt;set log_status on

  ...]]></description><category></category></item><item><title><![CDATA[oracle系列--取随机数]]></title><link>https://blog.youkuaiyun.com/samLin2018/article/details/80048218</link><guid>https://blog.youkuaiyun.com/samLin2018/article/details/80048218</guid><author>samLin2018</author><pubDate>Mon, 23 Apr 2018 11:31:39 +0800</pubDate><description><![CDATA[oracle取随机数函数      dbms_random.value   精确到38位的0到1                                     dbms_random.value (开始数，结束数)依然精确到38位 oracle取整函数       ceil 取大值                               floor取小值例子:select ceil(...]]></description><category></category></item><item><title><![CDATA[oracle消除相同数据(多个字段)]]></title><link>https://blog.youkuaiyun.com/samLin2018/article/details/80036247</link><guid>https://blog.youkuaiyun.com/samLin2018/article/details/80036247</guid><author>samLin2018</author><pubDate>Sun, 22 Apr 2018 09:46:22 +0800</pubDate><description><![CDATA[distinct 和 group by 两种方法distinct：select distinct name from t1 能消除重复记录，但只能取一个字段，现在要同时取id,name这2个字段的值。select distinct id,name from t1 可以取多个字段，但只能消除这2个字段值全部相同的记录group by 所以用distinct达不到想要的效果，用group by   可...]]></description><category></category></item><item><title><![CDATA[hiberate系列]]></title><link>https://blog.youkuaiyun.com/samLin2018/article/details/79958836</link><guid>https://blog.youkuaiyun.com/samLin2018/article/details/79958836</guid><author>samLin2018</author><pubDate>Mon, 16 Apr 2018 12:05:00 +0800</pubDate><description><![CDATA[hiberate方法：query.uniqueResult().toString()  是返回唯一结果   例子	int personCount = Integer.parseInt(query.uniqueResult().toString());确定将返回唯一结果就用他	                        List list = query.list();   //返回结果集			...]]></description><category></category></item></channel></rss>