https://blog.youkuaiyun.com/jbgh608zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/jbgh608/article/details/4345677https://blog.youkuaiyun.com/jbgh608/article/details/4345677jbgh608Mon, 13 Jul 2009 22:03:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/2727156https://blog.youkuaiyun.com/jbgh608/article/details/2727156jbgh608Mon, 28 Jul 2008 21:49:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/2727140https://blog.youkuaiyun.com/jbgh608/article/details/2727140jbgh608Mon, 28 Jul 2008 21:47:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/2551234https://blog.youkuaiyun.com/jbgh608/article/details/2551234jbgh608Sun, 15 Jun 2008 23:06:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/2551231https://blog.youkuaiyun.com/jbgh608/article/details/2551231jbgh608Sun, 15 Jun 2008 23:03:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/2120285https://blog.youkuaiyun.com/jbgh608/article/details/2120285jbgh608Mon, 25 Feb 2008 23:14:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1873963https://blog.youkuaiyun.com/jbgh608/article/details/1873963jbgh608Thu, 08 Nov 2007 16:25:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1860750https://blog.youkuaiyun.com/jbgh608/article/details/1860750jbgh608Thu, 01 Nov 2007 10:38:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1860718https://blog.youkuaiyun.com/jbgh608/article/details/1860718jbgh608Thu, 01 Nov 2007 10:22:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1854686https://blog.youkuaiyun.com/jbgh608/article/details/1854686jbgh608Mon, 29 Oct 2007 17:01:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1854615https://blog.youkuaiyun.com/jbgh608/article/details/1854615jbgh608Mon, 29 Oct 2007 16:31:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1854464https://blog.youkuaiyun.com/jbgh608/article/details/1854464jbgh608Mon, 29 Oct 2007 15:36:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1843015https://blog.youkuaiyun.com/jbgh608/article/details/1843015jbgh608Thu, 25 Oct 2007 11:53:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1842951https://blog.youkuaiyun.com/jbgh608/article/details/1842951jbgh608Thu, 25 Oct 2007 11:20:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1841461https://blog.youkuaiyun.com/jbgh608/article/details/1841461jbgh608Wed, 24 Oct 2007 11:47:00 +0800https://blog.youkuaiyun.com/jbgh608/article/details/1838769https://blog.youkuaiyun.com/jbgh608/article/details/1838769jbgh608Tue, 23 Oct 2007 10:28:00 +0800 select min(all sal) from gao.table3;MIN(ALLSAL) -----------     1111.1163.STDDEV(distinct|all) 求标准差,ALL表示对所有的值求标准差,DISTINC]]>https://blog.youkuaiyun.com/jbgh608/article/details/1838761https://blog.youkuaiyun.com/jbgh608/article/details/1838761jbgh608Tue, 23 Oct 2007 10:27:00 +0800 select to_char(sysdate,yyyy/mm/dd hh24:mi:ss) from dual;TO_]]>https://blog.youkuaiyun.com/jbgh608/article/details/1838754https://blog.youkuaiyun.com/jbgh608/article/details/1838754jbgh608Tue, 23 Oct 2007 10:26:00 +0800 select exp(2),exp(1) from dual; EXP(2)    EXP(1)--------- --------- 7.3890561 2.718281823.FLOOR 对给定的数字取整数 SQL> select floor(2345.67) from dual; FLOOR(2345.67) --------]]>https://blog.youkuaiyun.com/jbgh608/article/details/1838748https://blog.youkuaiyun.com/jbgh608/article/details/1838748jbgh608Tue, 23 Oct 2007 10:24:00 +0800 select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; A         A      ZERO     SPACE --------- --------- --------- --------- 65       ]]>https://blog.youkuaiyun.com/jbgh608/article/details/1838674https://blog.youkuaiyun.com/jbgh608/article/details/1838674jbgh608Tue, 23 Oct 2007 10:04:00 +0800