Lesson 7: Inserting data

In this lesson, you insert some more data into the remote and consolidated databases using the new schema.

Prérequis

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Changing a schema using the script version clause.

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.

Using Interactive SQL, execute the following SQL statements on the remote database.

INSERT INTO customer VALUES( 3, 'Mo Hamid', '613-411-9999', '613-502-1212' );
COMMIT;

Using Interactive SQL, execute the following SQL statements on the consolidated database.

INSERT INTO customer VALUES( 101, 'Theo Tug', '212-911-7677', '212-311-3900' );
COMMIT;

Résultat

Data is inserted into the remote and consolidated databases using the new schema.

Suivant

Proceed to Lesson 8: Synchronizing.

Discuter à propos de cette page dans DocCommentXchange.