When you SELECT from a view, it shows the information relevant to the current schema, the one with which you connected.
I spent hours trying to figure out why a view was showing data which had nothing to do with what i expected to see, until i figured out (with a little help from my friends) that it shows quite different things if you're logged in with the SYSTEM schema. I should have viewed it in an application-specific schema.
No comments:
Post a Comment