View vs Materialized View | Oracle SQL
Every Java Developer is expected to have basic knowledge of database like SQL Queries, joins, having clause, group by, views, stored procedures, cursors, triggers, etc. If you are preparing for Java / J2EE interview, you should also prepare basic SQL interview questions. In our previous article on SQL interview Questions, we have seen differences between UNION and UNION […]
UNION Vs UNION ALL | Oracle SQL
Though both UNION and UNION ALL is used to combine results of two SELECT queries, the main difference between them is that UNION doesn't include duplicate records, but UNION ALL does. Another difference between them is that UNION ALL is faster than UNION , but may look slow because it returns more data which takes more […]
