作者:empty 出版社:empty |
SQL*XL provides an easy to use bridge between Excel and Oracle databases. SQL*XL adds a new menu item to Excel so Oracle access appears to be native. Through comprehensive dialogs you have interaction with the database.
From Oracle...
SQL is taken from a dialog box, spreadsheet or file. The data is put in the spreadsheet where you want it.
To Oracle...
A full spreadsheet full of data can be inserted with one click. When constraints are violated you are prompted with the full Oracle error message. Transaction control lets you rollback or commit the changes.
Update Oracle...
Once data is fetched into Excel, SQL*XL allows you to edit it in the spreadsheet. When you are done, the changes can be updated in Oracle with one mouse click. Optionally SQL*XL will asks you to confirm each individual change.