Difference between revisions of "Oracle:Section5"
From mi-linux
Jump to navigationJump to search (Created page with "Main Page >> Oracle and SQL >> Workbook >> Section 5 answers == Exercise 5.1 == 5.1 Insert a new employee to department 20, with a hiredat...") |
|||
| Line 5: | Line 5: | ||
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. | 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-2015 9:00', 'DD-MON-YYYY hh:mi'), 3400, 0, 20); | ||
| + | COMMIT; | ||
---- | ---- | ||
Return to the [[Oracle_Workbook|Workbook]]. | Return to the [[Oracle_Workbook|Workbook]]. | ||
Revision as of 15:32, 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-2015 9:00', 'DD-MON-YYYY hh:mi'), 3400, 0, 20);
COMMIT;
Return to the Workbook.
