2 Replies Latest reply on Nov 12, 2012 1:20 PM by 973776

    sinlge select query in different schemas for same table(Indentical Structu)

      Scenario :

      Table XYZ is created in Schema A
      After an year, the old data from the previous year would be moved to different schema. However in the other schema the same table name would be used.

      For eg

      Schema A contains table XYZ with data of 2012 yr
      Schema B contains table XYZ with data of 2011 yr
      Table XYZ in both the schemas have identical structure.

      So can we fire a single select query to read the data from both the tables in effective way.
      Eg select * from XYZ where date range between 15-Oct-2011 to 15-Mar-2012.
      However the data resides in 2 different schema altogether.