–日期获取
select trunc(sysdate,'yyyy') from dual; --获取当前年第一天
select last_day(add_months(trunc(SYSDATE,'y')+1-1/86400,11)) from dual --获取当前年最后一天 到时分秒
select TRUNC(SYSDATE-1)+1-1/86400 FROM dual; --获取昨天最后一天 到时分秒
select trunc(add_months(sysdate,-3),'mm') from dual; --三个月前第一天
select trunc(last_day(add_months(sysdate,-1)))+1-1/86400 from dual; --上月最后一天
select (TRUNC(SYSDATE, 'YYYY') - INTERVAL '1' YEAR) from dual; --上一年第一天
----表赋权限
grant select, insert, update, delete on goods_gd_permission to SVCTEMP;
----存储过程的包 赋权限
grant execute on HRYY_SVC_MOBILE_BP_PKG to SVCTEMP;
----建同义词
create or replace synonym SVCTEMP.gd_goodsinfo_ensure_v
for SVCDATA.gd_goodsinfo_ensure_v;
后续慢慢添加