BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Practical DevOps Architecture
Practical DevOps Architecture
Sep 29, 2024 · Databases

Comprehensive Oracle Database Tutorial Series (Download, Installation, SQL Basics, PL/SQL, and Advanced Topics)

This article provides a detailed list of 51 video tutorials covering Oracle database download, installation, basic SQL operations, DML/DQL commands, PL/SQL programming, advanced features, and related database administration topics, offering a complete learning path for Oracle practitioners.

AdvancedInstallationOracle
0 likes · 6 min read
Comprehensive Oracle Database Tutorial Series (Download, Installation, SQL Basics, PL/SQL, and Advanced Topics)
dbaplus Community
dbaplus Community
Nov 25, 2020 · Databases

How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds

This article examines how openGauss implements Oracle SQL compatibility, covering query syntax like ROWNUM and DUAL, unsupported CONNECT BY, HINT handling, execution‑plan commands, Oracle functions such as DECODE, SYSDATE, NVL/NVL2, PL/SQL UDFs, stored procedures, triggers, cursors, VARRAYs, and provides a detailed compatibility summary.

Oracle compatibilityPL/SQLSQL dialect
0 likes · 13 min read
How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds
ITPUB
ITPUB
Aug 29, 2017 · Databases

Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons

The article explains how set‑based SQL queries outperform procedural, row‑by‑row approaches by showing concrete examples, AUTOTRACE statistics, and PL/SQL function alternatives, highlighting massive differences in consistent gets, recursive calls, and overall resource consumption for large production data sets.

PL/SQLProceduralSet-Based
0 likes · 7 min read
Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons
ITPUB
ITPUB
Mar 21, 2017 · Databases

How to Double Oracle Data Load Speed with Bulk Inserts and Parallelism

This article explains why frequent small commits are slower than a single bulk SQL operation, demonstrates how to rewrite PL/SQL procedures to use bulk inserts, adjust UNDO settings, and enable parallel execution, achieving up to six‑fold performance gains on large data loads.

Bulk InsertOraclePL/SQL
0 likes · 9 min read
How to Double Oracle Data Load Speed with Bulk Inserts and Parallelism
ITPUB
ITPUB
Mar 8, 2017 · Databases

5 Ways to Upsert in Oracle vs MS SQL – Practical Code Examples

This article compares how to create tables and perform upsert (insert‑or‑update) operations in MS SQL and Oracle, presenting five distinct Oracle techniques—including implicit cursor, exception handling, dual table, no_data_found, and MERGE—each with complete PL/SQL code samples.

OraclePL/SQLSQL Server
0 likes · 8 min read
5 Ways to Upsert in Oracle vs MS SQL – Practical Code Examples
dbaplus Community
dbaplus Community
Nov 3, 2016 · Databases

Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization

A detailed case study describes how a rapidly growing edit‑log feature caused query times to soar to 30 seconds, and walks through the step‑by‑step investigation, identification of a custom function bottleneck, data‑volume analysis, and the eventual implementation of partitioning, mandatory time filters, and composite indexing to restore acceptable performance.

PL/SQLPartitioningdatabase
0 likes · 12 min read
Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization
ITPUB
ITPUB
Oct 5, 2016 · Databases

How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools

This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.

BackupExportImport
0 likes · 5 min read
How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools
ITPUB
ITPUB
Jun 9, 2016 · Databases

Fix Chinese Garbled Text in Oracle SQL*Plus on Windows and Linux

This guide explains why Chinese characters appear garbled in PL/SQL and SQL*Plus on Windows and Linux, shows how to verify the Oracle server character set, configure the NLS_LANG environment variable, adjust terminal encoding, and ensure client‑server encoding consistency.

LinuxOraclePL/SQL
0 likes · 4 min read
Fix Chinese Garbled Text in Oracle SQL*Plus on Windows and Linux
ITPUB
ITPUB
Jun 2, 2016 · Databases

How to Efficiently Delete Massive Data Sets with a PL/SQL Procedure

This article explains a practical PL/SQL stored‑procedure technique for bulk‑deleting large tables by batching rows, using rowid partitioning, off‑peak execution, and short pauses to minimize impact on Oracle database performance.

OraclePL/SQLStored Procedure
0 likes · 3 min read
How to Efficiently Delete Massive Data Sets with a PL/SQL Procedure
ITPUB
ITPUB
May 26, 2016 · Databases

Understanding PL/SQL Collections: Index‑by Tables, Nested Tables, and VARRAYs

This article explains Oracle PL/SQL collection types—index‑by tables, nested tables, and VARRAYs—detailing their definitions, initialization rules, element access, practical code examples, and the built‑in methods available for manipulating these collections.

CollectionsIndex-by TableNested Table
0 likes · 7 min read
Understanding PL/SQL Collections: Index‑by Tables, Nested Tables, and VARRAYs
ITPUB
ITPUB
May 4, 2016 · Databases

Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide

This article explains Oracle trigger fundamentals, syntax, and a series of practical examples—including preventing weekend updates, auto‑incrementing IDs, logging DML actions, aggregating department salaries, capturing deletions, view‑based inserts, salary change alerts, and tracking CREATE/DROP operations—complete with full SQL code snippets.

OraclePL/SQLTriggers
0 likes · 12 min read
Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide
ITPUB
ITPUB
Dec 3, 2015 · Databases

SQL Tic‑Tac‑Toe Challenge: Generate Endgame Boards and Find Forced Wins

The ITPUB community revived its SQL Database Programming Contest, outlining judges, prize tiers, and detailed rules, then presenting two Oracle‑SQL puzzles—one to generate every possible tic‑tac‑toe endgame board and another to determine a forced winning strategy for a given board—plus an optional extension for larger m,n,k games.

ContestPL/SQLTicTacToe
0 likes · 9 min read
SQL Tic‑Tac‑Toe Challenge: Generate Endgame Boards and Find Forced Wins
dbaplus Community
dbaplus Community
Oct 23, 2015 · Databases

How Oracle CBO Calculates Range Predicate Selectivity and Handles Strings

This article explains how Oracle's Cost‑Based Optimizer estimates the selectivity of range predicates without histograms, demonstrates calculations with sample data, shows PL/SQL code for converting string values to internal numbers, and discusses pitfalls such as identical internal values causing cardinality errors, offering solutions like gathering histograms or using DATE columns.

CBODatabase OptimizationOracle
0 likes · 8 min read
How Oracle CBO Calculates Range Predicate Selectivity and Handles Strings