Oracle 系统变量函数用法指南

select sysdate from dual;
insert into purchase values
(‘Small Widget','SH',sysdate, 10);
insert into purchase values
(‘Meduem Wodget','SH',sysdate-15, 15);

select * from purchase where purchase_date between (sysdate-30) and sysdate;

select user from dual;

select userenv(‘TERMINAL') FROM dual;