Add rows to table

In this demo rows will be added to a table. SQL*XL's multiple rows insert form is opened and still contains the data from the demo on how to insert data into a new table.

 

Selecting the data field allows the selection of cells on the spreadsheet. Instead of scrolling down I use the keyboard shortcut Shift-Ctrl-Down. This will select all the contiguous rows and in the data field the address of the cell range is displayed.

 

The insert into Oracle completed within a second. One error was encountered. A description was bigger than allowed. Errors are (optionally) sorted to the top for convenience. As you can see, errors are quickly fixed.

 

A query on the whole table verifies the add rows operation.