Manipulating Data in Oracle Database 10g

To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements

Familiarity with RDBMS technologies and programming techniques

Database administrators, application developers, and database operators

WEB

Using DML statements to insert data in Oracle 10g| - insert rows into a table.|Modifying and removing rows in Oracle 10g tables| - update and delete rows in a table.|Using DML statements in Oracle 10g| - insert, update, and delete data.|Database transactions in Oracle 10g databases| - control data changes and identify how read consistency is implemented.|Controlling database transactions in Oracle 10g| - control data changes using the COMMIT, SAVEPOINT, and ROLLBACK statements.|Manipulating large datasets in Oracle 10g databases| - manipulate data in Oracle 10g by using subqueries.|Multitable INSERT statements in Oracle 10g| - use various types of multitable inserts.|Multitable MERGE statements and data tracking| - use the MERGE statement and the Flashback Version Query feature.|Using multitable statements in an Oracle 10g database| - perform multitable INSERT and MERGE operations, and track row versions.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...