Transferred from CAMIS How-to’s. These instructions are based on TOAD.
Backup Production data prior to making changes:
IMPORTANT: Before updating any data, backup the result set, returned by the script, to your local drive. Once the change is approved and moved to 'Done” you can also delete the backup. |
---|
To backup the data from TOAD:
right click anywhere in the result set (rows that were returned).
Select export data from the “pop-up” menu”.
Settings highlights:Export format: Excel file.
Output: set the path and filename for the file you will be saving.
In the Date format section, I recommend enabling the the checkbox “Hide time portion if zero
Example settings (TOAD).
0 Comments