dual

create table A(
id number(2) primary key,
temp date
);

commit;

insert into A values (1,to_date('2016-1-1','yyyy-mm-dd'));

commit;

select * from A;

drop table A;

select to_char(sysdate,'yyyy-mm-dd') from dual;

select 2*10 from dual;

select 7+4 from a;

原文地址:https://www.cnblogs.com/Yxxxxx/p/6884407.html