100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 4 out of 8 pages.
Direction: Follow the steps accordingly.1.Download the DEPARTMENTS table. 2.Copy and paste the pl/sql code used during the creation of DEPARTMENTStable. 3.After copying all the values inside the DEPARTMENTS table type in COMMITfollowed by semicolon to end your statement.Note: Succeeding numbers requires you to use Departments table. Perform thefollowing transaction as instructed in each number. Skipping one step may causeincorrect answer. If there is/are question(s) that you have to explain based on the outputwrite your answer (in Red Color Font) for each question.Table 1.0Current State of Departments table.1.Update the DEPARTMENT_NAME to PROMODIZER of all departments whereLOCATION_ID is equal to 1700.(Add the PL/SQL used Here)2.After updating records in No. 1, create a savepoint rename your savepoint asUPDATE_PROMO.
(Add the PL/SQL used Here)3.Delete the record of MANAGER_ID that is/are equal to NULL or blank.(Add the PL/SQL used Here)4.After updating records in No. 3, create a savepoint rename your savepoint asDELETE_NULL;(Add the PL/SQL used Here)5.Check the changes made in DEPARTMENTS table and study by issuingSELECT * command.6.After checking the changes made from No. 1 - 4. Add additional department asshown belowDEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID70CLERK100120040IT1001300(Add the PL/SQL used Here)