<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[QLZXing的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/QLZXing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; QLZXing]]></copyright><item><title><![CDATA[用PTHON写循环 对比用ORACLE语句]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127562783</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127562783</guid><author>QLZXing</author><pubDate>Thu, 27 Oct 2022 23:14:14 +0800</pubDate><description><![CDATA[python:参考大神>>>>   https://blog.youkuaiyun.com/cui_yonghua/article/details/95719103。dbms_output.put_line('1-100内奇数的和:'||sum1);dbms_output.put_line('1-100内偶数的和:'||sum2);4..求所有的水仙花数。]]></description><category></category></item><item><title><![CDATA[sqoop操作：从0到1]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127450186</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127450186</guid><author>QLZXing</author><pubDate>Fri, 21 Oct 2022 17:12:09 +0800</pubDate><description><![CDATA[sqoop操作：从0到1]]></description><category></category></item><item><title><![CDATA[存储过程经典例题演示：按科目统计分数段的人数；把各科成绩显示在一条记录里。]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127094015</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127094015</guid><author>QLZXing</author><pubDate>Wed, 28 Sep 2022 17:47:52 +0800</pubDate><description><![CDATA[存储过程经典例题演示：按科目统计分数段的人数；把各科成绩显示在一条记录里。]]></description><category></category></item><item><title><![CDATA[sql子查询超经典例题：--连续3天登录的用户筛选]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127093978</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127093978</guid><author>QLZXing</author><pubDate>Wed, 28 Sep 2022 17:45:34 +0800</pubDate><description><![CDATA[sql子查询超经典例题：--连续3天登录的用户筛选]]></description><category></category></item><item><title><![CDATA[索引和sql优化]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127075978</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127075978</guid><author>QLZXing</author><pubDate>Tue, 27 Sep 2022 18:14:54 +0800</pubDate><description><![CDATA[索引和SQL优化]]></description><category></category></item><item><title><![CDATA[全量和增量]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127062247</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127062247</guid><author>QLZXing</author><pubDate>Mon, 26 Sep 2022 22:18:30 +0800</pubDate><description><![CDATA[需求：把stu表中的数据，迁移到一张新的表stu2中;
此时，stu2表可能存在，也可能不存在。]]></description><category></category></item><item><title><![CDATA[包 创建分两步：1.包的定义2.包的实现；视图；触发器]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127062116</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127062116</guid><author>QLZXing</author><pubDate>Mon, 26 Sep 2022 22:14:09 +0800</pubDate><description><![CDATA[包 创建分两步：1.包的定义2.包的实现;视图；触发器]]></description><category></category></item><item><title><![CDATA[自定义函数]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127051311</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127051311</guid><author>QLZXing</author><pubDate>Mon, 26 Sep 2022 12:13:32 +0800</pubDate><description><![CDATA[自定义函数]]></description><category></category></item><item><title><![CDATA[存储过程：单变量 到sys_refcursor]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/127008142</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/127008142</guid><author>QLZXing</author><pubDate>Fri, 23 Sep 2022 11:57:17 +0800</pubDate><description><![CDATA[存储过程：单变量 到sys_refcursor]]></description><category></category></item><item><title><![CDATA[游标：显式游标和隐式游标,系统游标]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126999924</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126999924</guid><author>QLZXing</author><pubDate>Thu, 22 Sep 2022 21:12:34 +0800</pubDate><description><![CDATA[游标]]></description><category></category></item><item><title><![CDATA[语句块中异常处理]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126999871</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126999871</guid><author>QLZXing</author><pubDate>Thu, 22 Sep 2022 21:04:23 +0800</pubDate><description><![CDATA[exception]]></description><category></category></item><item><title><![CDATA[循环： LOOP,FOR,WHILE]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126999584</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126999584</guid><author>QLZXing</author><pubDate>Thu, 22 Sep 2022 20:57:04 +0800</pubDate><description><![CDATA[循环： LOOP,FOR,WHILE]]></description><category></category></item><item><title><![CDATA[行转列decode，Case When,IF ELSE]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126999420</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126999420</guid><author>QLZXing</author><pubDate>Thu, 22 Sep 2022 20:48:32 +0800</pubDate><description><![CDATA[行转列decode，Case When,IF ELSE]]></description><category></category></item><item><title><![CDATA[正则表达式]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126999271</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126999271</guid><author>QLZXing</author><pubDate>Thu, 22 Sep 2022 20:36:28 +0800</pubDate><description><![CDATA[正则表达式专用的函数
REGEXP_LIKE REGEXP_INSTR REGEXP_SUBSTR REGEXP_REPLACE]]></description><category></category></item><item><title><![CDATA[ORACLE经典练习：三表联查：sporter，item，grade]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126911178</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126911178</guid><author>QLZXing</author><pubDate>Sat, 17 Sep 2022 21:40:12 +0800</pubDate><description><![CDATA[A、	求出目前总积分最高的系名，及其积分。
B、	找出在一操场进行比赛的各项目名称及其冠军的姓名。
C、	找出参加了张三所参加的所有项目的其他同学的姓名。
D、	经查张三因为使用了违禁药品，其成绩都记0分，请在数据库中作出相应修改。
E、	经组委会协商，需要删除女子跳高比赛项目。]]></description><category></category></item><item><title><![CDATA[ORACLE经典作业：三表联查：EMP,DEPT,SALGRADE]]></title><link>https://blog.youkuaiyun.com/QLZXing/article/details/126910481</link><guid>https://blog.youkuaiyun.com/QLZXing/article/details/126910481</guid><author>QLZXing</author><pubDate>Sat, 17 Sep 2022 21:25:35 +0800</pubDate><description><![CDATA[1、	列出至少有一个员工的所有部门编号、名称，并统计出这些部门的平均工资、最低工资、最高工资。

2、	列出薪金比“SMITH”或“ALLEN”多的所有员工的编号、姓名、部门名称、其领导姓名。

3、	列出所有员工的编号、姓名及其直接上级的编号、姓名，显示的结果按领导年工资的降序排列。

4、	列出受雇日期早于其直接上级的所有员工的编号、姓名、部门名称、部门位置、部门人数。

5、	列出部门名称和这些部门的员工信息（数量、平均工资），同时列出那些没有员工的部门。

6、	列出所有“CLERK”（办事员）的姓]]></description><category></category></item></channel></rss>