fireship courses have helped me a lot to upgrade my next.js skills on a whole new level

I am learning a lot from fireship!

```scala
import scala.util.matching.Regex

object SQLProcessor {
  // Define a regular expression to match "database.table" patterns
  val dbTablePattern: Regex = """([a-zA-Z_][a-zA-Z0-9_]*)\.([a-zA-Z_][a-zA-Z0-9_]*)""".r

  def main(args: Array[String]): Unit = {
    // Sample SQL query
    val sqlQuery = "select * from my_database.my_table where job_d = MAX_JOB_ID;"

    // Step 1: Extract all database.table strings
    val dbTableMatches = dbTablePattern.findAllIn(sqlQuery).toList

    // Step 2: Build the Oracle query to fetch max_job_id values
    val oracleQuery = s"SELECT target_table, latest_job_id FROM rcn_source_entities WHERE target_table IN (${dbTableMatches.mkString(", ")})"

    // You can execute the Oracle query and fetch the results here

    // For demonstration purposes, let's assume the results are fetched as a Seq of (String, Int)
    val maxJobIds: Seq[(String, Int)] = Seq(
      ("my_database.my_table", 12345),
      // Add more (database.table, max_job_id) pairs as needed
    )

    // Step 3: Replace placeholders in the original SQL query
    val modifiedQuery = maxJobIds.foldLeft(sqlQuery) {
      case (query, (dbTable, maxJobId)) =>
        query.replaceAllLiterally(s"$dbTable.MAX_JOB_ID", maxJobId.toString)
    }

    // Print the modified SQL query
    println(modifiedQuery)
  }
}

```

test1

kjnk

# hello world!![alt](https://firebasestorage.googleapis.com/v0/b/nextfire-demo.appspot.com/o/uploads%2FzDfGdiszjCan0tsP41lTiSq7ppF3%2F1695577790154.jpeg?alt=media&token=88971104-2de0-4552-9ded-89b7da5691ab)

💡 Next.js + Firebase - The Full Course

I am learning a lot from fireship!

test1

kjnk

salut

Hi guys

bro as asdj kk

how to eat

Hello, testing the course

Anime

Nice