Lesson 7: Inserting data in the remote database

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

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

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;

Discuss this page in DocCommentXchange.