Lesson 4: Inserting data in the remote database

In this lesson, you insert data into the remote database to demonstrate that a schema change can proceed even if there are operations in the remote database that need to be uploaded.

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.

Task

Using the instance of Interactive SQL that is connected to the remote database, execute the following SQL statement to insert a row in the customer table.

INSERT INTO customer VALUES( 2, 'Sue Slow', '602-411-5467' );
COMMIT;

Résultat

The data is inserted into the remote database.

Suivant

Proceed to Lesson 5: Performing a schema change on the consolidated database.

Discuter à propos de cette page dans DocCommentXchange.