高浓除砂器
oracle中如何插⼊date类型的数据oracle中如何插⼊date类型的数据⽅法如下:rbf神经网络
insert into tabname(datecol) value(sysdate) ; -- ⽤date值
insert into tabname(datecol) value(sysdate+1) ; -- ⽤date值
insert into tabname(datecol) value(to_date('2014-02-14','yyyy-mm-dd')) ; -- ⽤to_date
insert into tabname(datecol) value(to_date('2014-02-14 20:47:00','yyyy-mm-dd hh24:mi:ss')) ; -- ⽤to_date新国学网
insert into tabname(datecol) value(to_date('20140214','yyyymmdd')) ; -- ⽤to_date
insert into tabname(datecol) value(to_date('20140214204700','yyyymmddhh24miss')) ; -- ⽤to_date
select table_name,tablespace_name from user_tables where table_name='EMP';
武汉科技
大学外语外事职业学院
drop table EMP;
create table EMP
(
EMPNO NUMBER(6) not null unique,
ENAME varchar2(20),
JOB varchar2(20),
MGR varchar2(20),
HIREDATE date,
SAL varchar2(20),
COMM varchar2(20),
DEPTNO varchar2(20)
);
INSERT INTO EMP VALUES(44449, '⼩明', '⼯程师', 'ligang',
to_date('20140214204700','yyyymmddhh24miss'), '1000', '12345', 'test');
commit;
人类
命运共同体5个内涵
ame,xx.,xx.hiredate,xx.sal,xxm,xx.deptnopgl2008
from (select rownum id1,emp.* from emp where rownum<4) xx
where id1>0;