From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Assignment: Manipulate data

Assignment: Manipulate data - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Assignment: Manipulate data

“

- [Lecturer] So in this next step of our assignment from our capstone, we're going to be manipulating data. There's no way to fix inventory changes when data transfers from one store to another inventory. So what we're going to do is fix it manually. We start by finding out how many women's green shirts are in each one of the stores. So you're going to have to create a query to select from each one of the stores and tell me the quantity of women's green shirts. So we're going to say that shirts are really popular, the green ones for women in Berlin, and we need to have more of them there. Vienna, they haven't been as popular. How are we going to do this? So you're going to need to change those quantities in the inventory for Berlin and Vienna manually. So you're going to add four shirts to Berlin while removing four from Vienna, and then you're going to need to verify those counts. I would recommend doing it before and after, and always remember to do those commits as part of this…

Contents