Countries
The details about the countries and provinces which are used to maintain accurate address information for the organizations and contacts in 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 Countries WHERE id = 12 SELECT * FROM Countries WHERE id > 15 SELECT * FROM Countries WHERE lookUpName LIKE '%test' SELECT * FROM Countries WHERE id IN (12, 23, 123) SELECT * FROM Countries WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the abbreviation, iSOCode and names columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO CountriesNames#TEMP (languageId, labeltext) VALUES ('7', 'Vietnam')
INSERT INTO Countries (phonecode, abbreviation, iSOCode, names) VALUES ('44', 'UK', 'UK', 'countriesNames#TEMP')
UPDATE
Update can be executed by specifying the column in WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Countries SET abbreviation = 'US of America' WHERE name = 'United States (US)'
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM Countries WHERE id = '4'
Columns
| Name | Type | ReadOnly | Description |
| Abbreviation | String | False |
The two or three character abbreviation for the country. For example, USA. |
| CreatedTime | Datetime | True |
The date and time when the country was created. This attribute is read-only. |
| DisplayOrder | Int | False |
The position of the country in the Countries/Provinces tree and drop-down menu. |
| ISOCode | String | False |
The ISO 3166 country code. |
| Id [KEY] | Long | True |
The unique identifier of the country. |
| LookupName | String | True |
The name used to look up the country. |
| Name | String | True |
A list of labels or names used for this country on each unique interface. |
| PhoneCode | String | False |
The international telephone code for the country. This is used by the Click-to-Dial feature. |
| PhoneMask | String | False |
The string having twice the number of characters in the phone number. Two characters are needed to represent every digit or character in the phone number. The first character of the mask describes the target character and the second constrains its type. |
| PostalMask | String | False |
The string having twice the number of characters in the target postal code. Two characters are needed to represent every digit or character in the postal code. The first character of the mask describes the target character and the second constrains its type. |
| UpdatedTime | Datetime | True |
The date and time when the country was last updated. This attribute is read-only. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| names | String |
The name of the country in the language of the current interface. This attribute is read-only. |
| provinces | String |
A list of states or provinces associated with this country. |