instructure-uploads.s3.amazonaws.com #4. How do you undo the change you made in
ID: 3724036 • Letter: I
Question
instructure-uploads.s3.amazonaws.com #4. How do you undo the change you made in Questions #2 & #3? ( I.e. it is only ONE command to undo all of the changes that you made. ) Write the SQL code to delete the row for William Smithfield, who was hired on June 22, 2004, and information given in the problem. ) #6 #7 whose job code is 500. ( Hint use logical operators include all of the Show the code that created the first row in the "JOB" table. What would you expect the output to look like if you did a Natural Join on the 2 tables, showing only the columns of the employee's last name and the job type?Explanation / Answer
Note: I will update the question, once I get the list of tables, Employee and Job. Have some patience.
4.) Using the ROLLBACK command we can undo the changes till the last saved point.
5.) DELETE From EMPLOYEE
WHERE EMP_HIREDATE = 22-JUN-2004 AND JOB_CODE = 500;
6.) INSERT INTO JOB
VALUES(499,NULL,25.25);
7.)
EMP_LNAME JOB_TYPE Arbough Documentation Smithfield Documentation Alanzo Documentation Senior Training Ramcras Training Washington Training Smith Training News Consulting Johnson ConsultingRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.