Scraping Forex / Stock Data from Yahoo Finance and Analyzing it using Oracle Pattern Matching and R

In this video, we will take a look at the MATCH_RECOGNIZE clause in Oracle. Specifically, we will look at the following:

1. Scrape Foreign Exchange Symbols from a Yahoo Finance web page using
R libraries and Regular Expressions.
2. Retrieve Foreign Exchange and Stock data using R's tidyquant library.
3. Import data into an Oracle database.
4. Perform Match_Recognize pattern Analysis over the data.
5. Visualize results in R Studio using ggplot2.

Oracle Data Warehouse Guide 23c
------------------------------
https://docs.oracle.com/en/database/oracle/oracle-database/23/dwhsg/sql-pattern-matching-data-warehouses.html#GUID-136DAC89-DA17-45C6-9E37-C9892723AC79

GitHub Code:
--------------------
https://github.com/Tor-Storli/Oracle_Match_Recognize.git

Видео Scraping Forex / Stock Data from Yahoo Finance and Analyzing it using Oracle Pattern Matching and R канала Torbjorn Storli