JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Configurations

The information about the configuration settings within Oracle B2C Service.

Table-Specific Information

SELECT

The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.

SELECT * FROM Configurations WHERE id = 12
SELECT * FROM Configurations WHERE id > 15
SELECT * FROM Configurations WHERE lookUpName LIKE '%test'
SELECT * FROM Configurations WHERE id IN (12,23,123)
SELECT * FROM Configurations WHERE lookUpName IS NOT NULL

Columns

Name Type Description
CreatedTime Datetime The date and time when the configuration was created. This attribute is read-only.
DataTypeId Long Id of dataType. The type of data that the configuration represents.
DataTypelookUpName String LookUpName of dataType. The type of data that the configuration represents.
Id [KEY] Long The unique identifier of the configuration.
LookupName String The name used to look up the configuration.
Name String The name of the configuration.
UpdatedTime Datetime The date and time when the configuration was last updated. This attribute is read-only.
Value String The string value of the configuration. The value is either a site value or the value associated with the interface. The configuration values are stored and fetched from a file cache.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462