Manipulating Data |
||||||
In this module, you learn how to perform the ongoing tasks that are required to ensure you get the most out of Oracle Database Express Edition. Now that you have created tables in the database, you learn how to insert data into the tables, update existing data, and delete data that is no longer required. You also learn how to save the changes you are making.
When using these statements, you can also control your transactions by choosing to save your data by using COMMIT operations or discard changes by using a ROLLBACK operation You can also use the Object Browser interface to manage your data. You will watch Sheila manage data in the database. Sheila will be adding rows for new employees and also updating employee records for employees who have ben promoted or transferred to other departments. Sheila also needs to remove the records of employees who are no longer in the company. After she makes her changes, Sheila needs to make her changes permanent by saving them.
|