system/admin:数据库表scott方案下的emp
select * from scott.emp ORDER BY EMPNO
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(3,to_date('04-2月-2007','dd-Mon-yyyy'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(4,to_date('2007-1月-1','yyyy-Mon-dd'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(5,to_date('2007-1月-1','yyyy-Mon-dd HH-MI-SS'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(6,to_date('2007-1月-1','yyyy-Mon-dd HH:MI:SS'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(7,to_date('1月-2007-1','Mon-yyyy-dd HH:MI:SS'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(8,to_date('1月200701','Monyyyydd HH:MI:SS'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(9,to_date('20071月01','yyyyMondd HH:MI:SS'))
INSERT INTO SCOTT.EMP (empno,HIREDATE) values(10,to_date('20071月01','YYYYMonDD HH-MI-SS'))
INSERT INTO SCOTT.EMP
Oracle数据库日期型的插入(在PLSQL Developer上测试)
最新推荐文章于 2022-12-15 08:00:00 发布