select * from t_owners select distinct t.addressid,t.ownertypeid from t_owners t select trunc(120.5554654,3) from dual select substr('123456',4,1) from dual select sysdate from dual select add_months(sysdate,1) from dual select last_day(sysdate) from dual select trunc(sysdate) from dual select trunc(sysdate,'mm') from dual select '100'+0 from dual select '100'||0 from dual select sysdate hz from dual; select to_date('1997-03-06','yyyy-mm-dd') from dual select nvl(null,99) from dual select nvl2(null,to_char(88),'不限') from dual select rank() over(order by usenum desc) 排名,t.* from t_account t