Updating Bulk Records
The Update Bulk feature allows you to update one or more columns with the same value(s) simultaneously. For example, if you want the records in the result set to have the same start and end dates, you can use the Update Bulk feature.
To perform a bulk update on records
1. On the Menu toolbar, click Manage > Manage Data.
2. Navigate to the object that you want to edit and select it.
3. Display the records associated with the object, doing one of the following:
Click the
Values tab to display all the records associated with the object.
Enter filtering criteria to display only records that match specific values and click
Next.
4. Select the records to update and click Edit > Bulk Update.
5. Apply updates to fields, as needed. Use the appropriate update options for the data type as described in the following table. The NULLIFY option overwrites any existing value with a null value.
Data Type | Update Bulk Options |
Sequences | N/A except for Optional Database Sequence. Bulk-assign a sequence value. |
Numeric | Bulk-assign numeric values or NULLIFY existing values. |
Varchar | Bulk-assign varchar text, NULLIFY fields, or apply the update as follows: Prefix With: Adds the specified prefix to existing values. Suffix With: Adds the specified suffix to existing values. RPAD: Pad values right (for example: trailing zeros). LPAD: Pad values left (for example: leading zeros). |
Char | Bulk-assign char text or NULLIFY existing values. |
Date | Bulk-assign date or NULLIFY existing values. |
Boolean | Bulk-assign YES or NO. Boolean columns display as a drop down on the update bulk screen. Note: If the boolean column is selected to display as list, the update bulk option includes and Ignore option (to omit the column while updating). |
BLOB/CLOB | Bulk-attach the files. |
Note:
Primary keys cannot be updated and therefore do not display in the Update Bulk screen. Required fields cannot be assigned the NULLIFY attribute.
6. Click Save.