table1 = spark.read
.format("jdbc")
.option("url","jdbc:oracle:thin:USER/Password@host:port/db_name")
.option("driver","oracle.jdbc.driver.OracleDriver" )
.option("dbtable","table_name_1")
.load()


table2 = spark.read
    .format("jdbc")
    .option("url","jdbc:oracle:thin:USER/Password@host:port/db_name")
    .option("driver","oracle.jdbc.driver.OracleDriver" )
    .option("dbtable","table_name_2")
    .load()