<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[mdaefsc的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/mdaefsc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; mdaefsc]]></copyright><item><title><![CDATA[LAD和LEAD函数]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/140212987</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/140212987</guid><author>mdaefsc</author><pubDate>Fri, 05 Jul 2024 16:42:18 +0800</pubDate><description><![CDATA[ladlead原表。]]></description><category></category></item><item><title><![CDATA[ORACLE表分区的自动创建（PLSQL）]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/136449817</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/136449817</guid><author>mdaefsc</author><pubDate>Mon, 04 Mar 2024 13:34:55 +0800</pubDate><description><![CDATA[说明：1.分区名格式为 xxx_xxx_xxx_1991                         ]]></description><category></category></item><item><title><![CDATA[ORACLE （递归求和）有木有网友，可以帮我找个高效方案。]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/135934037</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/135934037</guid><author>mdaefsc</author><pubDate>Tue, 30 Jan 2024 15:24:28 +0800</pubDate><description><![CDATA[数据库]]></description><category></category></item><item><title><![CDATA[oracle截取（二）]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/135821302</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/135821302</guid><author>mdaefsc</author><pubDate>Wed, 24 Jan 2024 14:24:02 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[创建DPlink]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/135610161</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/135610161</guid><author>mdaefsc</author><pubDate>Mon, 15 Jan 2024 20:22:08 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[oracle截取（一）]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/135609786</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/135609786</guid><author>mdaefsc</author><pubDate>Mon, 15 Jan 2024 20:05:01 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[Not exists]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/135609726</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/135609726</guid><author>mdaefsc</author><pubDate>Mon, 15 Jan 2024 20:03:38 +0800</pubDate><description><![CDATA[存在于A，不存在于B。]]></description><category></category></item><item><title><![CDATA[用VScode做JAVA连接oracle数据库 java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver解决办法]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/133862642</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/133862642</guid><author>mdaefsc</author><pubDate>Mon, 16 Oct 2023 17:09:55 +0800</pubDate><description><![CDATA[java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver解决办法。查了很多教学方式，走了很多弯路，综合所得上面方法，希望帮到有需要的人。第一步：把oracle的安装路径下这个jar包放在JDK安装包里（如下）第二步:在vscode内部操作，然后重启vscode即可。用VScode做JAVA连接oracle数据库。]]></description><category></category></item><item><title><![CDATA[行转列的三种写法]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/129240138</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/129240138</guid><author>mdaefsc</author><pubDate>Mon, 27 Feb 2023 13:31:55 +0800</pubDate><description><![CDATA[sum( case when 季度 = 3 then 增长率 else NULL end) as “三季度”,for 季度 in(1 as"一季度", 2 as"二季度", 3 as"三季度", 4 as"四季度"));sum(decode(季度,‘1’, 增长率,null)) “一季度”,sum(decode(季度,‘2’, 增长率,null)) “二季度”,sum(decode(季度,‘3’, 增长率,null)) “三季度”，sum(decode(季度,‘4’, 增长率,null)) “四季度”]]></description><category></category></item><item><title><![CDATA[读取数据库数据，做直方图。]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/123847041</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/123847041</guid><author>mdaefsc</author><pubDate>Wed, 30 Mar 2022 15:10:05 +0800</pubDate><description><![CDATA[数据数据分析]]></description><category></category></item><item><title><![CDATA[python往数据库插数]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/123427487</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/123427487</guid><author>mdaefsc</author><pubDate>Fri, 11 Mar 2022 16:05:12 +0800</pubDate><description><![CDATA[插书操作]]></description><category></category></item><item><title><![CDATA[拆解一个长字段内容，长字段到一个新表(不加序列方式)]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/120901963</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/120901963</guid><author>mdaefsc</author><pubDate>Fri, 22 Oct 2021 11:06:42 +0800</pubDate><description><![CDATA[/*========================================================================================
EFFECT: 小程序数据预处理，拆解商品信息字段
TARGET_TABLE:
AUTHOR:GORKOR
DATE:2021-10-8
========================================================================================*/
PROCE]]></description><category></category></item><item><title><![CDATA[拆解一个长字段内容，长字段到一个新表]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/120676192</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/120676192</guid><author>mdaefsc</author><pubDate>Sat, 09 Oct 2021 18:19:11 +0800</pubDate><description><![CDATA[/*========================================================================================
EFFECT: 小程序数据预处理，拆解商品信息字段
TARGET_TABLE:
AUTHOR:GORKOR
DATE:2021-10-8
========================================================================================*/
PROCE]]></description><category></category></item><item><title><![CDATA[python代码打包EXE]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/120525797</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/120525797</guid><author>mdaefsc</author><pubDate>Tue, 28 Sep 2021 11:31:20 +0800</pubDate><description><![CDATA[首先：用CMD窗口找到需要打包的Python代码
盘选择D:
文件cd+文件名
然后：找到文件所在位置
输入 pyinstaller -F + 文件名.py  (这里第一次打包的小伙伴们记得加载pyintsaller包，语法是pip install pyinstaller)
其中可能会出现的问题
Module ‘PyQt5’ has no attribute ‘version’ 比如这种，需要我们
输入pip install -U setuptools
输入pip install PyQt5

...]]></description><category></category></item><item><title><![CDATA[python生成简单名片二维码（不带图片）]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/120510428</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/120510428</guid><author>mdaefsc</author><pubDate>Mon, 27 Sep 2021 15:53:05 +0800</pubDate><description><![CDATA[from segno import helpers
ename = input(“请输入姓名:”)
email = input(“请输入邮箱:”)
phone = input(“请输入电话:”)
newInfo = {}
newInfo[‘name’] = ename
newInfo[‘email’] = email
newInfo[‘phone’] = phone
qr = helpers.make_mecard(
name=ename,
email=email,
phone=phone
)
qr.sav]]></description><category></category></item><item><title><![CDATA[oracle服务器常用的一些命令]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/119730089</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/119730089</guid><author>mdaefsc</author><pubDate>Mon, 16 Aug 2021 12:01:35 +0800</pubDate><description><![CDATA[以oracle身份登录数据库 命令：su – oracle
进入Sqlplus控制台 命令：sqlplus /nolog
以系统管理员登录 命令：connect / as sysdba
启动数据库 命令：startup
如果是关闭数据库 命令：shutdown immediate
退出sqlplus控制台 命令：exit
进入监听器控制台 命令：lsnrctl
启动监听器 命令：start
退出监听器控制台 命令：exit
客户端重启oracle
WIN+R
services.msc

...]]></description><category></category></item><item><title><![CDATA[数据库IP变了，但是服务名不会变]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/119730024</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/119730024</guid><author>mdaefsc</author><pubDate>Mon, 16 Aug 2021 11:58:28 +0800</pubDate><description><![CDATA[服务器的主机，创建好了数据库，有自己的IP地址和服务器的名称。后面因为工作需要，我们的服务器改变搬迁了到别的地方，我们的ip地址改变了，我们其他的以前能连接我们的数据库的电脑也突然连不上我们的数据库了，一直现在无监听程序类似的报错。后面解决的问题是IP给现在的电脑IP，服务还是之前的那个服务名（这里一定要注意），不能错了。。。

...]]></description><category></category></item><item><title><![CDATA[远程连接数据库]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/119389993</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/119389993</guid><author>mdaefsc</author><pubDate>Wed, 04 Aug 2021 17:56:51 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/weixin_43861320/article/details/118888708?spm=1001.2014.3001.5501

]]></description><category></category></item><item><title><![CDATA[实现序列自增，增量插入数据]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/119346669</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/119346669</guid><author>mdaefsc</author><pubDate>Tue, 03 Aug 2021 11:36:12 +0800</pubDate><description><![CDATA[create or replace package stu_pkg as
procedure stu_q;
procedure stu_p;
end stu_pkg;
/
create or replace package body stu_pkg as
/*========================================================================================
EFFECT:维表数据插入临时表
TARGET_TABLE:student]]></description><category></category></item><item><title><![CDATA[存储过程的创建]]></title><link>https://blog.youkuaiyun.com/mdaefsc/article/details/119237567</link><guid>https://blog.youkuaiyun.com/mdaefsc/article/details/119237567</guid><author>mdaefsc</author><pubDate>Fri, 30 Jul 2021 09:41:53 +0800</pubDate><description><![CDATA[—包头
create or replace package scott.dwr_order_pkg as
–京东数据
procedure dwr_dd_order_JD_P(start_date date,
end_date   date,
store_id   number);
–天猫数据
procedure dwr_dd_order_TM_P(start_date date,
end_date   date,
store_id   number);
–苏宁数据
procedure dwr_dd_orde]]></description><category></category></item></channel></rss>