4 Replies Latest reply: May 24, 2013 10:15 AM by tparvaiz RSS

    how to access tables from multiple schemas

    tparvaiz
      Hi,

      I have access to 2 different schema (schema_a, Schema_B) through my APEX environment... I have a query that's based on tables from both the schemas... something like this

      select SCHEMA_A.table1.column1, table2.column2
      from
      SCHEMA_A.table1, table2

      it is giving me a message that table doesn't exist.

      Please advice.

      Thanks