JDBC Driver for Open Exchange Rates

Build 21.0.7930

Currencies

Query Currency symbols available from Open Exchange Rates.

Table Specific Information

Select

Select all Currency symbols:

SELECT * FROM Currencies

Select experimental Currencies:

SELECT * FROM Currencies WHERE ShowExperimental=true

Columns

Name Type References Description
Currency String Currency (3-letter code).
Name String Long name for the currency.

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
ShowExperimental Boolean Whether to show experimental currencies from the unofficial, black market, and alternative currencies list in OpenExchangeRates.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930