alter user scott account unlock ;
ALTER USER scott IDENTIFIED BY sys;
select * from emp;
create or replace package sendmsg is
procedure mymsg( ) ;
end sendmsg;
create or replace package body sendmsg is
procedure mymsg( ) is
begin
dbms_output. put_line( 5 )
end ;
end sendmsg;
call sendmsg. sendmsg( ) ;
add_months()函数 参数 负数 代表 往前 正数 代表 往后。
select to_char( add_months( trunc( sysdate) , - 1 ) , 'yyyymm' ) from dual;
select to_char( add_months( trunc( sysdate) , 1 ) , 'yyyymm' ) from dual;
select add_months( trunc( sysdate) , + 1 ) from dual;
select last_day( trunc( sysdate) ) from dual;
select to_char( trunc( sysdate, 'MONTH' ) , 'yyyy-mm-dd' ) First_DayOfMonth
, to_char( last_day( trunc( sysdate, 'MONTH' ) ) , 'yyyy-mm-dd' ) Last_DayOfMonth
from dual
select trunc( sysdate, 'MONTH' ) from dual;
select add_months( sysdate,+ 1 ) from dual;
select trunc( sysdate) from dual;
--下月首日
select trunc( add_months( sysdate, + 1 ) , 'MONTH' ) from dual;
select last_day( trunc( add_months( sysdate, + 1 ) ) ) from dual;
select sysdate, sysdate - interval '7' MINUTE from dual
select sysdate - interval '7' hour from dual
select sysdate - interval '7' day from dual
select sysdate, sysdate - interval '7' month from dual
select sysdate, sysdate - interval '7' year from dual
select sysdate, sysdate - 8 * interval '2' hour from dual