Tag: oracle

Difference Between Inline and Out-of-Line Constraints

Constraints, Database development

Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two...
Read More

Oracle Database Security: Database Auditing

Database administration, Security

In this article, I will continue with Oracle Database Security and I will present some important facts about standard database auditing,...
Read More

Database Security in Oracle

Database administration, Security

There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each...
Read More

Oracle Database Security – Encryption and Decryption

Database administration, Security

Data encryption is very important because it’s a way to protect the current and the archived data...
Read More

Example of Improving Query Performance with Indexes

Database administration, Database development, Indexes, Oracle, Performance Tuning

In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
Read More

50 Shades of Oracle Database Certification Exam

Database development

In this article, I would like to talk about one of the basic certifications from Oracle – Oracle Database SQL Certified Expert....
Read More

5 Ways to Update Data with a Subquery in Oracle SQL

Database administration, Work with data

A subquery is a powerful way to find the data you want to use for another query. They are often...
Read More

Comparison of Tree Graphs

Computer Environment, Languages & Coding

When developing an information system that also includes various processing of design and technological documentation, I faced the...
Read More

Oracle as Workaround of Mutating Tables

Computer Environment, Database development, Tables

The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger, resulting in the “ORA-04091:...
Read More

Oracle Regular Expressions. Dangerous Range

Computer Environment, Database development, Statements

An Oracle developer who often uses regular expressions in code sooner or later can face a...
Read More
Close