ddanil.com

CHAPTER 3. "Tuning. Statistics. Execution plan." and CHAPTER 4. "Table and index scan" have been added to Overview of Oracle architecture and performance tuning. Part 1.

Short overview about most popular topics as "task-answer" format:

All Oracle articles from https://ddanil/index.php/programming/sql have been updated.

New information has been added and some errors have been fixed.

Website updated (new PHP version, security patches, bug fixes, etc.).

Added to Oracle articles: some new info (difference between NVL and COALESCE, etc.), fixed errors, ... To Overview of group, analytical, and hierarchical queries added new functions (FIRST, LAST, NTILE).

Some examples helps understand it quickly.

Try to solve it.

Welcome to new version of ddanil.com

Imroved style and perfomance.

Now site have topics about:

1) Training examples for Oracle exams 1z0-071, 1z0-149 and some materials about Oracle Database;

2) VBA connection info to Oracle Database and some materials about VBA and Excel;

3) Info about accounting entries and rules with examples (according to Federal Law about Accounting in Russian Federation №402).

New chapter added to Overview of Oracle architecture and performance tuning. Part 1.