Lab2.docx - Direction Follow the steps accordingly 1 Download the DEPARTMENTS table 2 Copy and paste the pl\/sql code used during the creation of

Lab2.docx - Direction Follow the steps accordingly 1...

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 DEPARTMENTS table. 3. After copying all the values inside the DEPARTMENTS table type in COMMIT followed by semicolon to end your statement. Note: Succeeding numbers requires you to use Departments table. Perform the following transaction as instructed in each number. Skipping one step may cause incorrect answer. If there is/are question(s) that you have to explain based on the output write your answer (in Red Color Font) for each question. Table 1.0 Current State of Departments table. 1. Update the DEPARTMENT_NAME to PROMODIZER of all departments where LOCATION_ID is equal to 1700. (Add the PL/SQL used Here) 2. After updating records in No. 1, create a savepoint rename your savepoint as UPDATE_PROMO.
Image of page 1
(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 as DELETE_NULL; (Add the PL/SQL used Here) 5. Check the changes made in DEPARTMENTS table and study by issuing SELECT * command. 6. After checking the changes made from No. 1 - 4. Add additional department as shown below DEPARTMENT_ID DEPARTMENT_NAME MANAGER_I D LOCATION_ID 70 CLERK 100 1200 40 IT 100 1300 (Add the PL/SQL used Here)
Image of page 2
7.
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture