Is there a way which I could determine Select withing particular schema only ? I've tried with all_users,dba_users and owner but I can't get It to work. What I want is to include a schema name in Select - something like this:
SELECT field1 FROM MyTable
WHERE field2='Test'
AND owner='Myschema';
thanks for help in advance!