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
Oracle相关sql
最新推荐文章于 2024-05-19 13:33:03 发布