You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

SQL(Table) to get the Countries with Phone Country codes

Summary:

If we need to fetch the country codes for Phones, this table is really useful. Please see the SQL.

Content (required):

SELECT TERRITORY_CODE, PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES

The above sql can be modified as required.

Version (include the version you are using, if applicable):

23C and above

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT TERRITORY_CODE, PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES

The above sql can be modified as required.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!