oracle常见sql积累

select lower('HELLO') from dual;
select lpad(100, 5, '*') from dual;
select sysdate + 1 / 24 from dual;
select last_day(sysdate) from dual;
select to_char(sysdate,'year-month-DD day HH24:MI:SS') from dual;

转载于:https://www.cnblogs.com/save-shengfei/p/6264134.html