tailieunhanh - Manipulating data

Once your tables have been created, you will need to add new rows, make changes to rows in a table, or delete rows by using data manipulation commands. This lesson covers using SQL commands to make changes to data. A number of these data manipulation commands make up a transaction, which you may either save or delete using transaction controls. At the end of this lesson, you should be able to Insert new rows into a table. Update existing rows in a table. Delete rows from a table. Explain transaction controls and their importance | 11 Manipulating Data ORACLG Objectives Insert new rows into a table. Update existing rows in a table. Delete rows from a table. Explain transaction controls and their importance. Schedule Timing 45 minutes 40 minutes 85 minutes Topic Lecture Practice Total Class Management Note Files required for this lesson are Demonstration Practice None 11-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives Once your tables have been created you will need to add new rows make changes to rows in a table or delete rows by using data manipulation commands. This lesson covers using SQL commands to make changes to data. A number of these data manipulation commands make up a transaction which you may either save or delete using transaction controls. At the end of this lesson you should be able to Insert new rows into a table. Update existing rows in a table. Delete rows from a table. Explain transaction controls and their importance. Manipulating Data .