Category: Oracle


What Is Oracle Materialized View

Today, I want to talk about Oracle Materialized View. What is Oracle Materialized View, it looks like a copy of a view or table. It is same as a table with row data. A...


How To Make View In Oracle

Today, I would like to talk about how to make views in Oracle. But before that I want to tell you when we need a view in Oracle.  You can use views in many...


How To Make Subquery In Oracle

Today, I want to talk about to make Subquery in Oracle.  A subquery is a SELECT statement that nested inside another statement such as SELECT, INSERT, UPDATE, or DELETE. You need this operations for...