```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

WITH ranked_data AS (
  SELECT
    job_id,
    RANK() OVER (ORDER BY job_id DESC) AS rnk
  FROM
    table1
)
SELECT
  job_id
FROM
  ranked_data
WHERE
  rnk = 1;

Anonymous User

test1

test