SQL, PL/SQL, and Oracle Application Express Articles


(See also: Oracle Database 11g: The Top New Features for DBAs and Developers)

Hide from Prying Eyes [January 2014]
by Arup Nanda
Use Data Redaction in Oracle Database 12c to hide sensitive data automatically.

On Oracle Database 12c, Part 3 [January 2014]
by Tom Kyte
Our technologist improves partitions, adapts query plans, and optimizes statistics gathering.

Sophisticated Call Stack Analysis [January 2014]
by Steven Feuerstein
UTL_CALL_STACK package in Oracle Database 12c gives developers better answers.

On Oracle Database 12c, Part 2 [November 2013]
by Tom Kyte
Our technologist finds a match for his SQL and makes his undo temporary.

SQL in PL/SQL Enhancements [November 2013]
by Steven Feuerstein
Oracle Database 12c enhances writing and executing SQL in PL/SQL

PL/SQL Enhancements [September 2013]
by Steven Feuerstein
Oracle Database 12c enhances the PL/SQL function result cache, improves PL/SQL execution in SQL, adds a whitelist, and fine-tunes privileges.

On Oracle Database 12c, Part 1 [September 2013]
by Tom Kyte
Our technologist improves default values, handles bigger datatypes, and FETCHes for the first time.

Pivotal Access to Your Data: Analytic Functions, Concluded [July 2013]
by Melanie Caffrey
Part 12 in a series on the basics of the relational database and SQL

On Randomness, Syntax, and Mutation [July 2013]
by Tom Kyte
Our technologist gets deterministic, delimited, and the opposite of trigger-happy.

On Efficiency, Avoidance, and Performance [May 2013]
by Tom Kyte
Our technologist uses brutally efficient DDL, answers trick questions, and suggests a scalar subquery.

Leading Ranks and Lagging Percentages: Analytic Functions, Continued [May 2013]
by Melanie Caffrey
Part 11 in a series on the basics of the relational database and SQL

On Becoming Others, Limits, and Restoration [March 2013]
by Tom Kyte
Our technologist assumes identities, eliminates external limitations, and recovers constraints.

A Window into the World of Analytic Functions [March 2013]
by Melanie Caffrey
Part 10 in a series on the basics of the relational database and SQL

Working with Cursors [March 2013]
by Steven Feuerstein
Part 12 in a series of articles on understanding and using PL/SQL

Wrap Your Code in a Neat Package [January 2013]
by Steven Feuerstein
Part 11 in a series of articles on understanding and using PL/SQL

Having Sums, Averages, and Other Grouped Data [January 2013]
by Melanie Caffrey
Part 9 in a series on the basics of the relational database and SQL

On Promotion, Restriction, and Data Loading [January 2013]
by Tom Kyte
Our technologist provides missing links, custom sizes, and external table tips.

The Data Dictionary: Make Views Work for You [November 2012]
by Steven Feuerstein
Part 10 in a series of articles on understanding and using PL/SQL

Beginning Performance Tuning: Diagnose the Past [November 2012]
by Arup Nanda
Take the next step in diagnosing Oracle Database performance issues.

Selecting a Type That Is Right for You [November 2012]
by Melanie Caffrey
Our technologist queries the operating system, locks manually, and uses the right NULL.

On External Table Queries, Data Consistency, and Nothing [November 2012]
by Tom Kyte
Our technologist queries the operating system, locks manually, and uses the right NULL.

On Clustering Factor and Validating Keys [September 2012]
by Tom Kyte
Our technologist explains different statistics and very foreign keys.

From Floor to Ceiling and Other Functional Cases [September 2012]
by Melanie Caffrey
Part 7 in a series on the basics of the relational database and SQL

Make the Easy Move [September 2012]
by Jeff Smith
Quickly copy, compare, and synchronize databases with Oracle SQL Developer.

Bulk Processing with BULK COLLECT and FORALL [September 2012]
by Steven Feuerstein
Part 9 in a series of articles on understanding and using PL/SQL

On Characters, Pivots, and Endings [July 2012]
by Tom Kyte
Our technologist substitutes characters, looks at fishy results, and avoids redo.

A Function of Character [July 2012]
by Melanie Caffrey
Part 6 in a series on the basics of the relational database and SQL

Working with Collections [July 2012]
by Steven Feuerstein
Part 8 in a series on understanding and using PL/SQL

Exploring Oracle SQL Developer [May 2012]
by Przemyslaw Piotrowski
Oracle’s flagship product for developing, managing and tuning databases has come a long way since its inception in 2006. 

Working with Records [May 2012]
by Steven Feuerstein
Part 7 in a series of articles on understanding and using PL/SQL

An Order of Sorts [May 2012]
by Melanie Caffrey
Part 5 in a series on the basics of the relational database and SQL

On Connection Pools, Cursor Differentiation, and Optimal Ordering [May 2012]
by Tom Kyte
Our technologist cleans pools, explores cursor types, and looks for order in table creation.

Why WHERE Matters [March 2012]
by Melanie Caffrey
Part 4 in a series on the basics of the relational database and SQL

On Unlearning and Modeling [March 2012]
by Tom Kyte
Our technologist goes back to school for Oracle Exadata and vows to be a MODEL student.

Error Management [March 2012]
by Steven Feuerstein
Part 6 in a series of articles on understanding and using PL/SQL

Getting Answers with SELECT [Jan. 2012]
by Melanie Caffrey
Part 3 in a series on the basics of the relational database and SQL

On History, Basics, and Network Performance [Jan. 2012]
by Tom Kyte
Our technologist recalls a Web seminar, gives the right hint, and dishes on network performance.

Working with Dates in PL/SQL [Jan. 2012]
by Steven Feuerstein
Part 5 in a series of articles on understanding and using PL/SQL

Modeling and Accessing Relational Data [Oct. 2011]
by Melanie Caffrey
Part 2 in a series on the basics of the relational database and SQL

On Collaboration, Testing, When, and Why [Oct. 2011]
by Tom Kyte
Our technologist learns from you, is tested on testing, and propagates errors.

Working with Numbers in PL/SQL [Oct. 2011]
by Steven Feuerstein
Part 4 in a series of articles on understanding and using PL/SQL

Get Your Information in Order [Sep. 2011]
by Melanie Caffrey
Part 1 in a series on the basics of the relational database and SQL

On Caching and Evangelizing SQL [Sep. 2011]
by Tom Kyte
Our technologist caches scalar subqueries, votes for SQL, and recommends technology and community.

Troubleshooting Internal Errors [Sep. 2011]
by Tamzin Oscroft
A guide to assessing and resolving ORA-600 and ORA-7445 errors

Working with Strings [Sep. 2011]
by Steven Feuerstein
Part 3 in a series of articles on understanding and using PL/SQL

Oracle Database 11g Express Edition Quick Tour [Sept. 2011]
by Przemyslaw Piotrowski
The new Express Edition reflects essential updates to the Oracle Database code base since 10.2.0.1, and thus contains an avalanche of value for developers and DBAs.

On Better Loading and Fact-Checking [01-June-2011]
by Tom Kyte
Our technologist enjoys the rule of external tables and debunks index scan myths.

Controlling the Flow of Execution [01-June-2011]
by Steven Feuerstein
Part 2 in a series of articles on understanding and using PL/SQL.

On Deferring and Bulking Up [01-Apr-2011]
by Tom Kyte
Our technologist prefers not to defer and works to increase bulk.

On Tuning, Planning, and Contexts [01-Mar-2011]
by Tom Kyte
Our technologist tunes data models, plans for partitions, and puts SQL in context.

Building with Blocks [01-Mar-2011]
by Steven Feuerstein
Part 1 in a series of articles on understanding and using PL/SQL.

On History, Invisibility, and Moving [01-Jan-2011]
by Tom Kyte
Our technologist counts on histograms, proves hash tables by example, and moves CLOBs.

On Consistent Results, Different Constraints, and Unlearning [12-Oct-2010]
by Tom Kyte
Our technologist reads as of a consistent point in time, uses the right constraint, and revises old learning on unindexed foreign keys.

Customize Your Application Layout [12-Oct-2010]
by James L. Weaver
When stock layouts just won’t do, create custom layout managers in JavaFX.

On Popularity, Learning, and Unlearning [31-Aug-2010]
by Tom Kyte
Our technologist revisits a classic, recounts Cardinality Feedback, and remembers SQL*Plus.

Zoom in On Your Code [31-Aug-2010]
by Steven Feuerstein
Use PL/Scope to analyze your PL/SQL.

Looking at the New Edition [14-Oct-2009]
by Tom Kyte
Our technologist takes a first look at Oracle Database 11g Release 2.

Tune It Up [14-Oct-2009]
by Sushma Jagannath
New features in Oracle Database 11g improve and speed SQL tuning.

On DBMS_ROWID, Parsing, and Sizing [19-Aug-2009]
by Tom Kyte
Our technologist identifies rows, analyzes ratios, and fills space.

On Popularity and Natural Selection [01-June-2009]
by Tom Kyte
Our technologist optimizes away binds and promotes more-selective queries.

On Constraints, Metadata, and Truth [01-May-2009]
by Tom Kyte
Our technologist uses constraints to improve query performance.

On Wrong and Right [2-Mar-2009]
by Tom Kyte
Our technologist checks the documentation and tests the answers.

Improving Application Performance [2-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Baselines and Better Plans [2-Mar-2009]
by Arup Nanda
Use SQL plan management in Oracle Database 11g to optimize execution plans.

On Dynamic Sampling [18-Dec-2008]
by Tom Kyte
Our technologist samples dynamically, considers usage, and sets levels.

Managing Database Resources [18-Dec-2008]
by Sushma Jagannath
New features in Oracle Database 11g help you assess performance and limit I/O usage.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

On Separation and Counting [01-Nov-2008]
by Tom Kyte
Our technologist promotes more than one schema, counts partitions, and uses TKPROF.

New Ways to Flash Back [01-Nov-2008]
by Sushma Jagannath
Reverse transactions and track historical changes in Oracle Database 11g.

Programming Productively [01-Nov-2008]
by Sue Harper
Use Oracle SQL Developer to work efficiently with PL/SQL constructs.

The Trouble with Triggers [01-Sep-2008]
by Tom Kyte
Our technologist looks at trigger maintenance and implementation challenges.

Document, Monitor, and Manage [01-Sep-2008]
by Sue Harper
Take advantage of new features in Oracle SQL Developer 1.5.

On Redefinition, Nature, and Triggers [23-June-2008]
by Tom Kyte
Our technologist redefines tables, compares keys, and warns about DDL in triggers.

Managing File Versions [23-June-2008]
by Sue Harper
Edit files and use version control in Oracle SQL Developer 1.5.

The Power of Two [01-May-2008]
by David Peake
Use Oracle SQL Developer to aid Oracle Application Express development.

On Seeing Double in V$SQL [01-May-2008]
by Tom Kyte
Our technologist looks at SQL repetition in V$SQL and differences in cardinality.

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Making Database Connections [01-May-2008]
by Sue Harper
Connect to Oracle and third-party databases from Oracle SQL Developer.

Oracle Database 11g Redux [11-Feb-2008]
by Tom Kyte
Our technologist continues to explore Oracle Database 11g features.

Building Queries Visually [11-Feb-2008]
by Sue Harper
Use point-and-click, drag-and-drop, and query builder in Oracle SQL Developer.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

On Tuning by Tracing [01-Jan-2008]
by Tom Kyte
Our technologist does a tune-up with SQL_TRACE.

More on Oracle Database 11g [18-Oct-2007]
by Tom Kyte
Our technologist takes another look at Oracle Database 11g.

Working with PL/SQL [18-Oct-2007]
by Sue Harper
Edit, compile, run, and debug PL/SQL code easily with Oracle SQL Developer.

Guide to Oracle Berkeley DB for SQL Developers [24-Sept-2007]
by Margo Seltzer
Get an introduction to using common SQL functions in Oracle Berkeley DB, from one of its inventors.

On Oracle Database 11g [17-Aug-2007]
by Tom Kyte
Our technologist takes a look at the server results and PL/SQL function caches.

Moving to an Oracle Database [17-Aug-2007]
by Sue Harper
Use Oracle Migration Workbench to migrate third-party schema objects to an Oracle database.

On Ignoring, Locking, and Parsing [21-June-2007]
by Tom Kyte
Our technologist looks out for WHEN OTHERS, locks, cascades, and parses.

Extending Oracle SQL Developer [21-June-2007]
by Sue Harper
Build extensions for Oracle SQL Developer with SQL and XML.

On Loading and Extents [11-May-2007]
by Sue Harper
Build chart, drill-down, and master/detail reports with Oracle SQL Developer.

Now Reporting [11-May-2007]
by Tom Kyte
Our technologist follows the direct path and optimizes extent usage.

On Cursors, SQL, and Analytics [11-Mar-2007]
by Tom Kyte
Our technologist referees between cursors, SQL statements, analytics, and aggregates.

On Top- n and Pagination Queries [17-Jan-2007]
by Tom Kyte
Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK.

Testing Database Security [26-Oct-2006]
by Aradhana Puri
Questions and answers on securing your Oracle database by using FGA and VPD

On Rescue Analytics and Popularity [26-Oct-2006]
by Tom Kyte
Our technologist explains the saving power of analytics and shares popularity.

On ROWNUM and Limiting Results [28-Aug-2006]
by Tom Kyte
Our technologist explains how ROWNUM works and how to make it work for you.

On Speeding, Dating, and Spelling [01-Jul-2006]
by Tom Kyte
Our technologist finds the OS, makes things appear faster, dates clients, and spells out numbers.

Build Custom Aggregate Functions [01-Jul-2006]
by Jonathan Gennick
Summarize data in new ways by writing your own aggregate functions.

Oracle SQL Developer Soars [01-May-2006]
by Jonathan Gennick
Bring the power of a GUI-based workbench to SQL and PL/SQL.

On Joins and Query Plans [01-May-2006]
by Tom Kyte
Our technologist optimizes joins and explains changing plans.

On Deduping and Ordering [01-Jan-2006]
by Tom Kyte
Our technologist deletes duplicates, gives trigger orders, and explains how SELECT locks.

SQL Tools Make Fast Work [01-Jan-2006]
by Jonathan Gennick
Different SQL tools run code, return results, and offer helpful differences.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

On Sharing, Splitting, and Deleting [01-Jan-2006]
by Tom Kyte
Our technologist shares cursors, splits large tables, and deletes securely.

Bitmap Index vs. B-tree Index: Which and When? [March 2005]
by Vivek Sharma

Response Time Analysis Made Easy in Oracle Database 10g [March 2005]
by Robin Schumacher