Configuring Heterogeneous Database Replication – SQL Server to Oracle
Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from...
Difference Between Inline and Out-of-Line Constraints
Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two ways of creating constraints on a...
Oracle Database Security: Database Auditing
In this article, I will continue with Oracle Database Security and I will present some important facts about standard database auditing,...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes...
Oracle Database Security – Encryption and Decryption
Data encryption is very important because it’s a way to protect the current and the archived data in order to ensure its confidentiality....
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
50 Shades of Oracle Database Certification Exam
In this article, I would like to talk about one of the basic certifications from Oracle – Oracle...
5 Ways to Update Data with a Subquery in Oracle SQL
A subquery is a powerful way to find the data you want to use for another query. They are often used in SELECT and UPDATE statements to...
Comparison of Tree Graphs
When developing an information system that also includes various processing of design and technological documentation, I faced the...
Oracle as Workaround of Mutating Tables
The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger,...
