VIEW: XTR.XTR_MARKET_PRICES#

Source

View Text - Preformatted

select ARCHIVE_FREQ_TYPE ARCHIVE_FREQ_TYPE, ASK_PRICE ASK_PRICE, BID_PRICE BID_PRICE, CURRENCY_A CURRENCY_A, CURRENCY_B CURRENCY_B, DDE_CONVERSATION_CODE DDE_CONVERSATION_CODE, DOWNLOAD_FREQ_TYPE DOWNLOAD_FREQ_TYPE, FREQ_ARCHIVE FREQ_ARCHIVE, FREQ_DOWNLOAD FREQ_DOWNLOAD, LAST_ARCHIVE_TIME LAST_ARCHIVE_TIME, LAST_DOWNLOAD_TIME LAST_DOWNLOAD_TIME, MOVEMENT_INDICATOR MOVEMENT_INDICATOR, NOS_OF_DAYS NOS_OF_DAYS, ORAFIN_ARCHIVE_FREQ_TYPE ORAFIN_ARCHIVE_FREQ_TYPE, ORAFIN_LAST_ARCHIVE_TIME ORAFIN_LAST_ARCHIVE_TIME, PARTY_CODE PARTY_CODE, PRICE_DESCRIPTION PRICE_DESCRIPTION, REF_NUMBER REF_NUMBER, RIC_CODE RIC_CODE, SOURCE SOURCE, SPREAD_BASIS SPREAD_BASIS, TERM_LENGTH TERM_LENGTH, TERM_TYPE TERM_TYPE, TERM_YEAR TERM_YEAR, UPDATE_RATE_YN UPDATE_RATE_YN, DAY_COUNT_BASIS DAY_COUNT_BASIS from "XTR"."XTR_MARKET_PRICES"

View Text - HTML Formatted

SELECT ARCHIVE_FREQ_TYPE ARCHIVE_FREQ_TYPE
, ASK_PRICE ASK_PRICE
, BID_PRICE BID_PRICE
, CURRENCY_A CURRENCY_A
, CURRENCY_B CURRENCY_B
, DDE_CONVERSATION_CODE DDE_CONVERSATION_CODE
, DOWNLOAD_FREQ_TYPE DOWNLOAD_FREQ_TYPE
, FREQ_ARCHIVE FREQ_ARCHIVE
, FREQ_DOWNLOAD FREQ_DOWNLOAD
, LAST_ARCHIVE_TIME LAST_ARCHIVE_TIME
, LAST_DOWNLOAD_TIME LAST_DOWNLOAD_TIME
, MOVEMENT_INDICATOR MOVEMENT_INDICATOR
, NOS_OF_DAYS NOS_OF_DAYS
, ORAFIN_ARCHIVE_FREQ_TYPE ORAFIN_ARCHIVE_FREQ_TYPE
, ORAFIN_LAST_ARCHIVE_TIME ORAFIN_LAST_ARCHIVE_TIME
, PARTY_CODE PARTY_CODE
, PRICE_DESCRIPTION PRICE_DESCRIPTION
, REF_NUMBER REF_NUMBER
, RIC_CODE RIC_CODE
, SOURCE SOURCE
, SPREAD_BASIS SPREAD_BASIS
, TERM_LENGTH TERM_LENGTH
, TERM_TYPE TERM_TYPE
, TERM_YEAR TERM_YEAR
, UPDATE_RATE_YN UPDATE_RATE_YN
, DAY_COUNT_BASIS DAY_COUNT_BASIS
FROM "XTR"."XTR_MARKET_PRICES"