ORACLE 一些函数

select replace(decode('12',0,'0.00',to_char(12,9999999999.99)),' ','')  from dual;
select * from(
  select  * from  t_user_login_log where  to_date(LOGIN_TIME,'yyyy.mm.dd hh24.mi.ss')  between (sysdate-1/24) and sysdate  order by LOGIN_TIME desc
        )   where rownum in(1,2,3);
   
      select to_char(12,'9999999.9') from dual;
      select to_char(12,'9999999999.99')  from dual;
      select replace('a b c',' ','')  from dual;
       select lpad('tech', 7,0) from dual;
      select rpad('tech', 7,0) from dual;