Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select within schema

LuckyLuke82Jul 13 2017 — edited Aug 13 2017

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!

This post has been answered by unknown-7404 on Jul 13 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2017
Added on Jul 13 2017
19 comments
635 views