oracle练习
ak01_10
这个作者很懒,什么都没留下…
展开
-
datetime_sdrf
select --power(2,10)--exp(10)--exp(1)--ln(8)--to_date('2018-10-02 22:11:02','yyyy-mm-dd hh24:mi:ss')--extract(minute from to_timestamp('2018-10-02 22:11:02','yyyy-mm-dd hh24:mi:ss'))--date'2018-01-10'...原创 2018-04-22 01:39:06 · 162 阅读 · 0 评论 -
str_sdf
select --ascii('\r\n')--chr(92) \--chr(13) 换行--trim('s' from 'sdfafsfabck') dfafsfabck--rtrim(' df d','d') - df ----ltrim(' dfs d','dsf') --dfs d----ltrim(' dfd d ') --dfd d----substr('wecanwin',3) c-...原创 2018-04-22 02:14:40 · 217 阅读 · 0 评论 -
排序
with t as (select rownum*10 cnt from dual connect by rownum<5union allselect rownum*40-10 from dual connect by rownum<3)select cnt,row_number() over(order by cnt)rn ,rank() over(order by cnt) rk...原创 2018-04-28 20:26:19 · 169 阅读 · 0 评论