Oracle UNION with Examples

In this tutorial, we will be learning about the UNION and UNION ALL set operator in Oracle. The set operators work on the same principle as set operators in mathematics. Before we begin understanding the set operators in Oracle, lets revisit the concept of set...

The Basics of Oracle Inline View with Examples

View in Oracle are nothing but a name given to SELECT query and is like a virtual table allowing us to execute this query by calling View instead of writing the entire SELECT query again. Inline Views have a similar function and are used for simplifying complex...

Oracle Updatable View With Examples

We previously learned about the concept of Views in Oracle and how we can create, update and delete them using simple queries. In practice, A view is just like a table from which we can fetch data using SQL queries. But its not always possible to update the data of...

Oracle View with Practical Examples

What is a View in Oracle? A View in Oracle simply represents a SQL query that’s stored in memory by Oracle so that we can call and reuse it multiple times, without having to write the complete query again. A view does not store any data and it simply executes...

Oracle CHECK Constraint with Examples

CHECK constraint is used for specifying condition which must be true for all rows. While adding a CHECK constraint to a column we create a logical expression which either returns true or false. All the values we try to insert in the column after applying CHECK...

Oracle NOT NULL Constraint

NOT NULL Constraint is used in Oracle for specifying that a column cannot contain NULL Values. This is an inline constraint that’s mentioned adjacent to the column name and its data type when creating a new table. In this tutorial, we will learn how to add and...