Artigos Oracle

Strange Oracle errors and their real reasons.

Performance Tips: Function Calls in WHERE Conditions.

Handling PL/SQL errors.

Top 10 Tips for Tuning Oracle SQL Query Performance.

Selecting an Index strategy.

Oracle index tips e techniques.

How to use DATEs, TIMESTAMPs, and INTERVALS in Oracle Database.

Oracle indexing myths.

How to generate days, weeks, or months between two dates in Oracle Database.

Are Non-Default Parameters Killing Your Oracle Database Performance?

How to Delete Duplicate Records in Oracle Database?

Find Oracle package or procedure that contains string.

Oracle basic articles collection,From beginners to advanced.

Difference between LATERAL JOIN and CROSS APPLY JOIN in Oracle 12c

Advantages of partitioning.

Reasons to use packages

Errors handling in BULK COLLECT and FORALL using SQL%BULK_EXCEPTIONS

Avoid Index Hints

Top 10 reasons of slow SQL code.

Condition after join vs where

Some Disadvantages of Allowing Null Values in Relational Databases.

Trilha do programador PL/SQL sr.

Flattening a subquery into a normal join.