Tagged articles
PL/SQL
15 articles · Page 1 of 1
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.
OraclePL/SQLSQL
0 likes · 6 min read

This article explains how the default PL/SQL delimiter '/' in OceanBase Oracle tenants conflicts with division operators, causing syntax errors, and demonstrates fixing the issue by changing the delimiter to '//' with detailed code examples and execution results.
OceanBaseOraclePL/SQL
0 likes · 6 min read

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


ITPUBAug 29, 2017 · Databases
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/SQLProceduralSQL
0 likes · 7 min read


ITPUBMar 21, 2017 · Databases
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.
OraclePL/SQLParallel Query
0 likes · 9 min read


ITPUBMar 8, 2017 · Databases
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.
Database MigrationOraclePL/SQL
0 likes · 8 min read

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/SQLPartitioningSQL
0 likes · 12 min read


ITPUBOct 5, 2016 · Databases
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.
ExportOraclePL/SQL
0 likes · 5 min read


ITPUBJun 9, 2016 · Databases
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


ITPUBJun 2, 2016 · Databases
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


ITPUBMay 26, 2016 · Databases
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.
Index-by TableNested TableOracle
0 likes · 7 min read


ITPUBMay 4, 2016 · Databases
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/SQLSQL
0 likes · 12 min read


ITPUBMar 15, 2016 · Databases
This guide shows how to split a delimited string into a one‑dimensional array in Oracle SQL using a custom hierarchical query, avoiding the restrictions of DBMS_UTILITY.UNCL_ARRAY and allowing any delimiter for flexible data processing.
OraclePL/SQLSQL
0 likes · 3 min read


ITPUBDec 3, 2015 · Databases
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/SQLSQL
0 likes · 9 min read

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.
CBOOraclePL/SQL
0 likes · 8 min read
