Ways to retrieve data from two tables with same column names
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
i have two table emp_registration and emp_login details. Two table having same Column name 'Emp_id'. I want to compare same Emp_id value is having in two table based on particular date. How to check this condition please help me.