In today’s article, we will be explaining the concept of Materialized Views in Oracle, also known as Snapshots. It is a structure that stores the …
Read More »Onur ARDAHANLI
Oracle Views
In this article, we will discuss the functions and types of Views in Oracle Database in detail. View is a virtual table that does not …
Read More »Partition Table – Primary Key
Global indexes become corrupted when a partition is dropped from the partition table and in this article we will learn how to fix these indexes …
Read More »Add Primary Key To A Column In A Table With Data
In today’s article, we will learn how to add a primary key to a column in a table containing data in an Oracle database. If …
Read More »Primary Key Creation Procedure
In today’s article we will be discussing the Primary Key Creation Procedures in Oracle Database. 1. Check if there is another Primary Key with the …
Read More »Deferrable Primary Key In Oracle
In today’s article, we may want it to come into play later when defining the Primary Key. For this, we will learn how to use …
Read More »Primary Key In Oracle
In today’s article, we will be explaining the concept of a primary key in Oracle, which is a single field or combination of fields that …
Read More »Constraints In Oracle
In today’s article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database. Oracle provides us with great …
Read More »Table Logging And Nologging
In today’s article, we will be learning how to Logging and Nologging the Table in the Oracle database. The logging_clause lets you specify whether certain …
Read More »Create Virtual Columns In Oracle
In today’s article, we will be learning how to Create a Virtual Column in Oracle Database. Virtual column value cannot be UPDATE. INDEX can be …
Read More »