oracle| Insert | data | database system/admin: Database table The EMP under the Scott scheme
SELECT * from Scott.emp ORDER by EMPNO
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (3,to_date (' April-February -2007 ', ' dd-mon-yyyy '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (4,to_date (' 2 July-January-1 ', ' yyyy-mon-dd '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (5,to_date (' 2 July-January-1 ', ' yyyy-mon-dd hh-mi-ss '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (6,to_date (' 2 July-January-1 ', ' yyyy-mon-dd HH:MI:SS '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (7,to_date (' January -2007-1 ', ' mon-yyyy-dd HH:MI:SS '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (8,to_date (' January 200701 ', ' Monyyyydd HH:MI:SS '))
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (9,to_date (' 20071 months ', ' yyyymondd HH:MI:SS ')
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (10,to_date (' 20071 months ', ' yyyymondd hh-mi-ss ')
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (11,to_date (' 20071 months ', ' yyyymondd hh-mi-ss ')
INSERT into SCOTT. EMP (Empno,hiredate) VALUES (12,to_date (' 20月-February -1981 12:00:00 ', ' dd-mon-yyyy HH:MI:SS '))
If you can't insert it, you can see a date field in the table after you log on to the Oracle EnTerprise Manager console. However, if you want to insert, you have to change the month to do it. Change the Chinese characters into Arabic numerals. I'm going to cut out the back. Just contact have what say wrong place also hope everybody a lot of advice!