<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lightningmn的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lightningmn</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lightningmn]]></copyright><item><title><![CDATA[v$parameter, v$parameter2, v$system_parameter, v$system_parameter2, v$spparameter区别]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/127930427</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/127930427</guid><author>lightningmn</author><pubDate>Fri, 18 Nov 2022 21:56:50 +0800</pubDate><description><![CDATA[v$parameter, v$parameter2, v$system_parameter, v$system_parameter2, v$spparameter区别]]></description><category></category></item><item><title><![CDATA[如何将Oracle 当前日期加一天、一分钟]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/108777028</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/108777028</guid><author>lightningmn</author><pubDate>Thu, 24 Sep 2020 16:21:41 +0800</pubDate><description><![CDATA[转载地址：https://blog.youkuaiyun.com/HyEidolon/article/details/8290724?utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2allbaidu_landing_v2~default-1-8290724.nonecase&amp;utm_term=oracle%20%E6%97%B6%E9%97%B4+2%E5%B0%8F%E6%97%B6
在Oralce中我发现有add_months函数]]></description><category></category></item><item><title><![CDATA[oracle 根据逗号拼接的数据进行查询，进行一一对应，json一一对应]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/108399009</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/108399009</guid><author>lightningmn</author><pubDate>Fri, 04 Sep 2020 10:20:35 +0800</pubDate><description><![CDATA[转载：https://blog.youkuaiyun.com/saygood999/article/details/102498385
注： to_char()函数的使用，是因为查询的数据乱码（数据集的问题），用to_char可以解决
oracle 12c不支持wm_concat，需要自己定义
select t.*,(select wm_concat(to_char(s.data_value)) from dev_common s where instr(t.attach_label_code,s.id)&gt;0) ]]></description><category></category></item><item><title><![CDATA[Oracle Apex 实用笔记系列 4 - 自定义javascript]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/107569343</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/107569343</guid><author>lightningmn</author><pubDate>Fri, 24 Jul 2020 20:45:33 +0800</pubDate><description><![CDATA[转载链接：https://blog.youkuaiyun.com/kswaking/article/details/40892579
对于自定义的javascript，有如下几种方式

页面加载
在组件视图

1.点击 编辑page
2.在javascript标签页的Function and global variable declaration处，书写自定义的javascript函数;
3.在Execute when page loads处调用或执行javascript代码
2.Dynamic Action
1.创建]]></description><category></category></item><item><title><![CDATA[Oracle并列排名显示]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/97275341</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/97275341</guid><author>lightningmn</author><pubDate>Thu, 25 Jul 2019 17:19:58 +0800</pubDate><description><![CDATA[转载地址：https://blog.youkuaiyun.com/WXB52112181314/article/details/80838567
第一种：dense_rank() over (order  by  字段  升序或降序)  as  别名  from 表名;
使用别名方便之后过滤条件使用；
排名的时候并列算同一个人，如，1，2，2，3
SQL&gt; select ename,job,sal,de...]]></description><category></category></item><item><title><![CDATA[#如何查看oracle的sid]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/96997079</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/96997079</guid><author>lightningmn</author><pubDate>Tue, 23 Jul 2019 15:10:47 +0800</pubDate><description><![CDATA[#如何查看oracle的sid
转载：https://www.cnblogs.com/lcword/p/8214334.html
1、怎样查看Oracle的数据库名称sid
用sysdba身份登录 比如 conn sys/密码 as sysdba 匿名管理员登陆
执行 select name form Vdatabase;（常用的方法）或是执行select∗fromVdatabase; （常用的方...]]></description><category></category></item><item><title><![CDATA[java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/86716817</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/86716817</guid><author>lightningmn</author><pubDate>Thu, 31 Jan 2019 16:46:36 +0800</pubDate><description><![CDATA[转载地址：https://blog.youkuaiyun.com/qq_39098813/article/details/81138648?utm_source=blogxgwz5
#从错误看应该是系统时间错误
Exception in thread &quot;main&quot; java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrec...]]></description><category></category></item><item><title><![CDATA[eclipse出现the jar file xxx.jar has no source attachment. 问题]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/86711138</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/86711138</guid><author>lightningmn</author><pubDate>Thu, 31 Jan 2019 09:44:42 +0800</pubDate><description><![CDATA[eclipse 查看不到源码问题
转载地址：https://blog.youkuaiyun.com/dancheng1/article/details/53940083
1.点 “window“-&amp;gt; “Preferences”-&amp;gt; “Java” -&amp;gt; “Installed JRES”；
2.此时&quot;Installed JRES&quot;右边是列表窗格，列出了系统中的JRE 环境，选择你的JRE，然后点...]]></description><category></category></item><item><title><![CDATA[Oracle授权相关(Oracle 触发器授权、Oracle 存储过程授权、Oracle 表授权、Oracle 序列授权)]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/85061142</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/85061142</guid><author>lightningmn</author><pubDate>Tue, 18 Dec 2018 10:37:40 +0800</pubDate><description><![CDATA[grant给表赋权限：
1、grant  权限 on 表  to 用户。
grant  select/update on  table to user；
例如：
grant select on table_name to user_name;
2、grant 给存储过程赋权限：
grant execute on 过程、包、方法 to user
grant execute on package/fu...]]></description><category></category></item><item><title><![CDATA[java中Class.forName方法的作用详解]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/83040756</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/83040756</guid><author>lightningmn</author><pubDate>Sat, 13 Oct 2018 17:58:20 +0800</pubDate><description><![CDATA[转载：https://www.jb51.net/article/117468.htm
前言
在做JAVA EE开发的过程中,更多的是使用框架来提高开发效率.越来越发现,之前很基础的一些东西,都忘记的差不多了.从今天开始慢慢的复习一下基础.今天在看JDBC的时候,就有一个有趣的地方,之前学的时候,也没在意.这个Class.forName究竟是什么鬼.
import com.mysql.jdbc.Dr...]]></description><category></category></item><item><title><![CDATA[关于MySql链接url参数的设置]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/83035707</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/83035707</guid><author>lightningmn</author><pubDate>Sat, 13 Oct 2018 09:47:36 +0800</pubDate><description><![CDATA[转载地址：https://www.cnblogs.com/softidea/p/5765624.html
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/database?useUnicode=true&amp;amp;characterEncoding=utf8&amp;amp;autoReconne...]]></description><category></category></item><item><title><![CDATA[谈谈字符集与字符编码]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/83035546</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/83035546</guid><author>lightningmn</author><pubDate>Sat, 13 Oct 2018 09:31:59 +0800</pubDate><description><![CDATA[转载地址：https://my.oschina.net/leejun2005/blog/232732#OSC_h3_4
这几天用到一家公司的短信 API，结果就遇到件囧事，因为编码格式不对，发过去的文字解析出了错误。于是就想到除了刚开始学习 web 的时候遇到过编码问题，似乎很久没有因为这个问题困扰过了，所以也就从没有仔细研究过，今天时间比较充裕，所以研究了下编码问题，特写博文一篇记录下心得体会。...]]></description><category></category></item><item><title><![CDATA[Front ConTroller(MVC) 前端控制器 (配生活实例解释)]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/82759713</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/82759713</guid><author>lightningmn</author><pubDate>Tue, 18 Sep 2018 16:30:49 +0800</pubDate><description><![CDATA[转载地址：
http://blog.youkuaiyun.com/qq_41247433	
https://blog.youkuaiyun.com/qq_41247433/article/details/79340490
前端控制器:
客户在页面输入
通过HTTP协议 利用request将数据(请求))带入前端控制器
前端控制器依据请求 指定对应的控制器 controller1/2/3
控制器依据业务实际 进行处理后 调...]]></description><category></category></item><item><title><![CDATA[Oracle 11g必须开启的服务及服务详细介绍]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/82750118</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/82750118</guid><author>lightningmn</author><pubDate>Mon, 17 Sep 2018 22:28:22 +0800</pubDate><description><![CDATA[转载网址：http://www.educity.cn/shujuku/404120.html
成功安装Oracle  11g数据库后，你会发现自己电脑运行速度会变慢，配置较低的电脑甚至出现非常卡的状况，通过禁止非必须开启的Oracle服务可以提升电脑的运行速度。那么，具体该怎么做呢?
按照win7 64位环境下Oracle 11g R2安装详解中的方法成功安装Oracle 11g后，共有7个服务，...]]></description><category></category></item><item><title><![CDATA[Oracle中dba_jobs表字段含义描述]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/81939032</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/81939032</guid><author>lightningmn</author><pubDate>Wed, 22 Aug 2018 10:11:36 +0800</pubDate><description><![CDATA[转载地址：https://blog.youkuaiyun.com/antma/article/details/79066948 
]]></description><category></category></item><item><title><![CDATA[oracle截取某一个字符之前或之后的值；substr();instr()]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/81223800</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/81223800</guid><author>lightningmn</author><pubDate>Thu, 26 Jul 2018 17:14:56 +0800</pubDate><description><![CDATA[原文链接：https://www.cnblogs.com/wangkang0320/p/6743965.html

函数介绍： 
截取的函数： 
substr(?,?); 
substr(?,?,?); 
 
获取目标字符出现的位置： 
instr(? , ? , ? ); 
instr( ? , ? , ? , ? ) 
 
例：

字符串 “AAA-BBB” 截取”AAA”  “BBB” 

...]]></description><category></category></item><item><title><![CDATA[oracle-comment on的用法]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/79761524</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/79761524</guid><author>lightningmn</author><pubDate>Fri, 30 Mar 2018 18:19:42 +0800</pubDate><description><![CDATA[转载：https://blog.youkuaiyun.com/wangmuming/article/details/28878461 
oracle中用comment on命令给表或字段加以说明，语法如下： 
COMMENT ON 
  { TABLE [ schema. ] 
    { table | view } 
  | COLUMN [ schema. ] 
    { table. | view....]]></description><category></category></item><item><title><![CDATA[Oracle常见授权与回收权限——grant和revoke]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/79759261</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/79759261</guid><author>lightningmn</author><pubDate>Fri, 30 Mar 2018 16:09:56 +0800</pubDate><description><![CDATA[转载：http://blog.itpub.net/27106350/viewspace-758652/ 
1.GRANT 赋于权限 
常用的系统权限集合有以下三个: 
CONNECT(基本的连接), RESOURCE(程序开发), DBA(数据库管理)

常用的数据对象权限有以下五个: 
ALL ON 数据对象名, SELECT ON 数据对象名, UPDATE ON 数据对象名, 
DELETE...]]></description><category></category></item><item><title><![CDATA[Oracle#v$session~~~~SID和Serial#的区别]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/79717428</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/79717428</guid><author>lightningmn</author><pubDate>Tue, 27 Mar 2018 18:36:50 +0800</pubDate><description><![CDATA[转载：https://blog.youkuaiyun.com/u013169075/article/details/52782385 
SID和Serial#共同确定一唯一的session。 
它们的定义如下： 
SID: Session identifier 
SERIAL#：Session serial number. Used to identify uniquely a session’s objec...]]></description><category></category></item><item><title><![CDATA[Oracle新建Schema]]></title><link>https://blog.youkuaiyun.com/lightningmn/article/details/79710660</link><guid>https://blog.youkuaiyun.com/lightningmn/article/details/79710660</guid><author>lightningmn</author><pubDate>Tue, 27 Mar 2018 11:36:06 +0800</pubDate><description><![CDATA[转载地址：https://www.cnblogs.com/mophy/p/6344917.html#undefined 
Oracle新建Schema

1.首先，创建（新）用户： 
    create user username identified by password; 
    username：新用户名的用户名 
    password: 新用户的密码 
也可以不创建新用户，而仍然...]]></description><category></category></item></channel></rss>