Inserting New Rows Using the INPUT Statement

An alternative to inserting new rows from the result set in Interactive SQL is to add rows using the INPUT statement with the PROMPT clause.

1. From Interactive SQL, add a row using the INPUT statement with the PROMPT clause. For example:

   INPUT INTO Products PROMPT;

2. Specify the value for each column when prompted.