Forum Stats

  • 3,769,977 Users
  • 2,253,041 Discussions
  • 7,875,257 Comments

Discussions

Sorry, the script used to populate the table.

insert into big_mac_index (country_name, country_iso, currency_code, local_price, dollar_exchange_rate, gdp_dollar, entry_date) 

select col001, col002, col003, col004, col005, col006, to_date(col007,'YYYY-MM-DD') from

 table(apex_data_parser.parse

  ( pcontent => apex_web_service.make_rest_request_b

   ('https://raw.githubusercontent.com/TheEconomist/big-mac-data/master/source-data/big-mac-source-data.csv', 'GET') , 

pfilename => 'big-mac-source-data.csv'

, pskip_rows => 1 ) 

);

Answers