Minor updates in Overview of Postgres group, analytical and recursive queries.
And brief info on TKPROF has been added to Overview of Oracle architecture and performance tuning. Part 2.
- Category: News
- Hits: 391
In SQL added Overview of Postgres group, analytical and recursive queries.
Breaf and quick.
Try to solve it.
- Category: News
- Hits: 458
Added examples for Training for the exam Java SE 17 Developer: 1Z0-829. Part 1.
- Category: News
- Hits: 446
Minor updates in Overview of Postgres group, analytical and recursive queries. Fixed some errors and queries are imporved.
Added info about TKProf to Overview of Oracle architecture and performance tuning. Part 2.
- Category: News
- Hits: 449
CHAPTER 6. "Hints" and CHAPTER 7. "Reading execution plan" have been added to Overview of Oracle architecture and performance tuning. Part 2.
- Category: News
- Hits: 1007
CHAPTER 5. "Join methods and types" have been added to Overview of Oracle architecture and performance tuning. Part 1.
- Category: News
- Hits: 1517
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.
- Category: News
- Hits: 1600
Short overview about most popular topics as "task-answer" format:
Overview of Oracle architecture and performance tuning. Part 1.
- Category: News
- Hits: 1624
All Oracle articles from https://ddanil/index.php/programming/sql have been updated.
New information has been added and some errors have been fixed.
- Category: News
- Hits: 969
Website updated (new PHP version, security patches, bug fixes, etc.).
- Category: News
- Hits: 1025
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).
- Category: News
- Hits: 1130
In SQL added Overview of group, analytical, and hierarchical queries.
Some examples helps understand it quickly.
Try to solve it.
- Category: News
- Hits: 1003
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).
- Category: News
- Hits: 1078