二.oracle内置函数

--oracle内置函数
--oracle默认表
select * from dual

select ABS(100),ABS(-100),ABS('100') from dual

select mod(12,0)  from dual

select cos(45) from dual

select Sqrt(12) from dual

select round(155.23456,-2) from dual
select trunc(155.23456,-2) from dual

select length('wgsaaklchz.,Xgbk;sfg;hfvsahgha') from dual

--按指定的方式排序
select * from productinfo order by  nlssort(proName,'NLS_SORT=schinese_pinyin_m')

select replace(description,'三星','韩国三星') from productinfo

 

 

select sysdate,dbtimezone from dual

select to_char(add_months(sysdate,2)) from dual

select avg(productinfo.proprice) from productinfo

select count(distinct proprice) from productinfo

select sum(quantity) from productinfo

select user from dual

select *
  from productinfo p
 where p.proprice < (select avg(p.proprice) from productinfo)