This discussion is archived
4 Replies Latest reply: May 24, 2013 8:15 AM by tparvaiz RSS

how to access tables from multiple schemas

tparvaiz Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points