You have three methods here. One, you could use a set operator like the UNION function. Two, you can do a join on the table. Three, you issue two separate SQL queries. In the case of DBA_SYS_PRIVS and DBA_TAB_PRIVS, the UNION function doesn't really apply since they have different columns. And there isn't a common column to join on either. So I'd issue two different SQL queries here.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.