<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[floatingleaf的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/floatingleafben</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; floatingleafben]]></copyright><item><title><![CDATA[Oracle列转行_看自SQL经典模式-列转行]]></title><link>https://blog.youkuaiyun.com/floatingleafben/article/details/83874355</link><guid>https://blog.youkuaiyun.com/floatingleafben/article/details/83874355</guid><author>floatingleafben</author><pubDate>Fri, 18 Mar 2011 17:36:08 +0800</pubDate><description><![CDATA[需求：
找出一些课程， 这些课程是由1位以上 男老师教，并且他们的级别大于3，并且他们年龄在40以下的。

课程表： 每门课程由5位老师教，要求包含老师的信息，以及一些课程的信息
create table course (id int, name varchar(100), teacher1 int,teacher2 int,teacher3 int, teacher4 int, teac...]]></description><category></category></item><item><title><![CDATA[SQLServer和Oracle常用函数对比]]></title><link>https://blog.youkuaiyun.com/floatingleafben/article/details/83874186</link><guid>https://blog.youkuaiyun.com/floatingleafben/article/details/83874186</guid><author>floatingleafben</author><pubDate>Fri, 18 Mar 2011 15:42:17 +0800</pubDate><description><![CDATA[数学函数 
　　1.绝对值 
　　S:select abs(-1) value 
　　O:select abs(-1) value from dual
 
　　2.取整(大) 
　　S:select ceiling(-1.001) value 
　　O:select ceil(-1.001) value from dual
 
　　3.取整（小） 
　　S:select flo...]]></description><category></category></item></channel></rss>