Difference between revisions of "Oracle:Section5"
From mi-linux
Jump to navigationJump to searchm (Protected "Oracle:Section5" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|||
| Line 6: | Line 6: | ||
INSERT INTO EMP | INSERT INTO EMP | ||
| − | VALUES (8000, 'SMITH', 'ANALYST', 7566, TO_DATE('01-JAN- | + | VALUES (8000, 'SMITH', 'ANALYST', 7566, TO_DATE('01-JAN-2016 9:00', 'DD-MON-YYYY hh:mi'), 3400, 0, 20); |
COMMIT; | COMMIT; | ||
Latest revision as of 15:35, 4 March 2016
Main Page >> Oracle and SQL >> Workbook >> Section 5 answers
Exercise 5.1
5.1 Insert a new employee to department 20, with a hiredate of the 1st January 2016 at 9am. Add appropriate values for the other columns.
INSERT INTO EMP
VALUES (8000, 'SMITH', 'ANALYST', 7566, TO_DATE('01-JAN-2016 9:00', 'DD-MON-YYYY hh:mi'), 3400, 0, 20);
COMMIT;
Return to the Workbook.
