SQL, PL/SQL, and Oracle Application Express Articles

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

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