第十二周

博主记录了一周的学习与生活。学习上,完成计组课程设计、准备PPT演讲、补人工智能课程、参加软件测试考试、学习数据库知识等;技术方面,接触A*、AO*算法和博弈树;生活中,有打篮球、玩游戏、购物聚餐等活动,还升级了VPN。

又到了疯狂回忆的时间。
马上就到了一个备份的时间。
备份回忆是一件一定要做的事情,我发现自己的记忆力也有所提升。
上周我写道:周一上午的完形全对。
这个事情在接下来的一周都称不上什么。
那天的之后,下午是计组的课程设计,我们需要做一个单周期CPU出来。于是我们就在搞这个事情,搞了很久。
我在自己的位置上做了很久的ppt,因为我第二天就要讲了。
然后我做得也差不多了。
增加了很多内容,然后还把PPT的风格罕见地改的很好看,至少能看懂。
写得差不多的时候已经是要上那个人工智能了。晚上我吃的M记的外卖。
吃完了,写完了,也快上课了。
我把上周的因为写ppt拉下的人工智能的课程补完,主要是第一节的内容。
然后去上课,记得好像讲了很久的A*算法。
然后我听的也比较认真。

周二的时候
我起来还在想这个ppt,然后改了一会。就中午了。
这个时候,整个ppt的雏形已经完全成长为真正的形态。
在这里插入图片描述
在这里插入图片描述

后来我的ppt演讲得很成功,我的舍友听说我要讲,都来看了。
那天上台前很紧张,但是上台之后出乎意料地很掌握整个环境,我发现这个东西只要你熟练,你就是最狠的,你需要对自己的所有内容非常熟悉,熟悉到不能再熟悉,我不仅各种增删改查,还对着计时器训练了很多遍,差不多都在10分钟-15分钟里。这个整个过程一下子就过去了。
为了不那么僵硬,我发现我竟然可以临时说一些很圆滑的话,让整个报告不至于像念ppt,但我的效果完全比念ppt好了很多,不只很多。
老师还在下面微笑,听到我一些很有个性的内容,频频微笑,看得出我比较对他的电波,我为了这个ppt,也为了自己的成长,阅读了大半个学期的《理想国》,这一刻很有得到回报的感觉。
感谢刘文艺老师,感谢他的马原,不愧为风评最好的马原老师,他就是我大学遇见的最好的老师,总是循循善诱,讲课十分慷慨激昂,不会说带有意识形态的话,反而能将那些书上的内容融合自己的理解,讲出能疏解我对世界的误解的讲述。
如果不是我作为一个软件工程的学生,我一定去他的手下当研究生,然后投身哲学的怀抱。可惜了,这个理想,我认为可能会在之后实现吧。

周二在这样的过程中就过去了。
那天的晚上,因为我需要第二天去BugKiller考试,我就提前看到了NextDay问题,还看了很多软件测试的书内容。
想着一定要考好。

周三
我上午是计网课,交了作业。老师竟然就要结课,我十分不舍。
这门课也比较有意思,但就还有一个月多。这结课让我确实有点没想到。

下午的时候我在干嘛来着,好像忘了,应该在记上午的笔记。但是晚上是决定性的考试,下午应该在睡觉。然后晚上带着篮球去做了。
整个过程很快。但FUCKING的是,有一个BUG我以为是系统BUG,我没多想,操!结果算我没找到这个BUG。失去了这个分数。
晚上跟4个人打篮球。
狠狠得打了一个傻逼的脸,对于这种人,我就一句话,嘴贱没有好下场。
进攻抹杀你的防守,在防守端漠视你的投篮,你能上进篮算我输,你能投篮进也算我输,最后我还是赢了,因为你在嘴贱的同时,也没有相应的努力付出或者实力作为自己的底气,对付这种人,我将今后,无论何时,遇到了,我就是你们这种人绝对的敌人。
场面十分解气。
我说了什么,“传球啊!我操!”类似这样的话,有些比较过分。
这在以前,我是不可能说这种话的,但我现在是变得柔情与绝情的了。我对自己认可的朋友亲人我绝对不会再对他们造成伤害,我会尽可能作为最真挚的伙伴或亲人。
也许你认为,我是那种好像把场面搞得很糟糕的人,但是我发现,其实不是,我在场上攻击的时候,大家鸦雀无声,对于平时温顺的我的大不同感到畏惧和无语,他们说不了什么,这时你要作为攻击者,隐藏自己温顺的天性,勇敢地出击,占领语言的高地,让所有人在你的语言场下进行游戏。
如果可以的话我很愿意提升所有领域的实力,然后将这种占领辐射到各种地方,前提是,在这个地方有我们的敌人。
对于 嘴贱 挑拨者 恶毒手段者 伤害我等者 非正义者 仇人 不尊重我等尊严的人,我将是战争。

不说这样的敏感的话,
周三在愉快的复仇下划下了句点。
感谢我的朋友czk和曾经的yhq,他们教会我一些语言攻击与防守的技巧。这让我进退巧妙,不再向恶人求饶。

周三回去之后,玩樱之诗玩到很晚。勉强进入了3.2这条线。
我打算等所有都完事,回包头通关,不能再和舍友搞这个了,GAL就应该是自己享受独自的事情。

周四
我上午是数据库,搞了很久NF定义那些,吃的早餐很不错。
然后在比较满意的结果下,完成了上午的课程。
然后就放假了。
之后,
我用周四下午晚上的时间。跟德伟用套路在峡谷虐人,充斥了快活的空气,看了一些健身视频,一些比较容易理解的编程视频。然后跟德伟冲了趟中山大学城,去GOGO超市购物,买了两杯奶茶喝,吃了章鱼丸子,讨论了学校的懒政,讨论了广东的食物,然后去小郡肝吃了很长时间。最后算下来,一人80大概。
说了说话,喝了点凉茶就回宿舍了。
晚上啥也再没吃,基本是睡觉了应该,还想看番,最后还是睡了。

周五的时候,醒来,上了很多厕所,吃辣还是不太好。差不多的时候
中午立即跟别人开始打LOL,赢多输少,小鱼人一个wq把别人戳死。真离谱
晚上吃了个面什么的。回来又点了夜宵。
晚上看了一堆什么视频大概。
睡了。

周六就特别离谱,跟同学开黑开了一整天。
然后杀得也很爽。我们几个特有意思,拿了个五杀,吃了点烧烤,睡了。

周日,12点才醒,然后吃了点饭,特难吃,然后看了那个浙江农业大学的事情,看了很久。
十分感叹,
然后躺了会。
起来开始写数据库。
写的差不多一个。
晚上跟外招同学他们打球打到9点。
认识了很好的朋友。竟然是阳江挂名外招。
回来搞了搞就差不多很想睡了。
这之中恐怖的在于,我换了一床被子,换了床单枕头罩那些的,累死我了。床夹的针拔不出来气死我了。累的我的腰要tama断了,操啊。
睡了。也看了很久视频什么的。

周一就是今天,
我上午的课很认真做了笔记,结果没带本,只能写纸上,晚上还花了一节课誊抄。中午喝了三得利乌龙茶不用休息。下午写了数据库前半部分。然后跟同学狂搞CPU,搞了差不多了。然后吃了饭。挺好的。回来换了厚衣服,把所有的衣服全部整理了遍。
去上课,AO*算法,那些也听不太懂,博弈树,也听了听。
具体都在刷手机的东西。看看这看看那的。
这天回来,现在,我把VPN升级了一个很好的,一个月用上优惠码才21.5,很舒服。将好歌一网打尽的计划又近了。然后我就开始写数据库。23点半才写完。开始写这个总结,写到现在。

睡了,兄弟!我们下周见!!!!

(Mathcad+Simulink仿真)基于扩展描述函数法的LLC谐振变换器小信号分析设计内容概要:本文围绕“基于扩展描述函数法的LLC谐振变换器小信号分析设计”展开,结合Mathcad与Simulink仿真工具,系统研究LLC谐振变换器的小信号建模方法。重点利用扩展描述函数法(Extended Describing Function Method, EDF)对LLC变换器在非线性工作条件下的动态特性进行线性化近似,建立适用于频域分析的小信号模型,并通过Simulink仿真验证模型准确性。文中详细阐述了建模理论推导过程,包括谐振腔参数计算、开关网络等效处理、工作模态分析及频响特性提取,最后通过仿真对比验证了该方法在稳定性分析与控制器设计中的有效性。; 适合人群:具备电力电子、自动控制理论基础,熟悉Matlab/Simulink和Mathcad工具,从事开关电源、DC-DC变换器或新能源变换系统研究的研究生、科研人员及工程技术人员。; 使用场景及目标:①掌握LLC谐振变换器的小信号建模难点与解决方案;②学习扩展描述函数法在非线性系统线性化中的应用;③实现高频LLC变换器的环路补偿与稳定性设计;④结合Mathcad进行公式推导与参数计算,利用Simulink完成动态仿真验证。; 阅读建议:建议读者结合Mathcad中的数学推导与Simulink仿真模型同步学习,重点关注EDF法的假设条件与适用范围,动手复现建模步骤和频域分析过程,以深入理解LLC变换器的小信号行为及其在实际控制系统设计中的应用。
declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; [42000][904] ORA-00904: "YYYY": 标识符无效 ORA-06512: 在 line 67
06-07
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值