Code Pumpkin

Category Archives: SQL

View vs Materialized View | Oracle SQL

September 10, 2017
Posted by Abhi Andhariya

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

May 28, 2017
Posted by Abhi Andhariya

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 […]

Total Posts : 124
follow us in feedly

Like Us On Facebook