My Oracle Support Banner

How to Replace Values in a JBot Table Column with Values from a Database Table Using a Custom Format (Doc ID 1482035.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.10.0 and later
Oracle Network Management for Utilities - DMS - Version 1.10.0 and later
Information in this document applies to any platform.

Goal

How can one replace all of the values in one column of a table with a corresponding value in a database table?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Creating and Using the Lookup Table
 Step 1 - Define the query
 Step 2 - Define the datastore
 Step 3 - Create the custom format java class
 Step 4 - Use the custom format
 Step 5 - Install the config changes


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.