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.
Tagged:
1