Subscribe

Author Profile

Tom Kyte

In his 22 years at Oracle, Tom Kyte started the Ask Tom question and answer site and was the site's sole proprietor for almost 15 years. In his spare time, he also wrote Expert Oracle Database Architecture (Apress, 2005, 2010, 2014) and Effective Oracle by Design (Oracle Press, 2003), among other books. (The Ask Tom site continues today as Ask TOM: Ask The Oracle Masters.)

On ROWNUM and Limiting Results

Our technologist explains how ROWNUM works and how to make it work for you. By Tom Kyte September/October 2006 This issue's Ask Tom column is a little different...

On Speeding, Dating, and Spelling

Our technologist finds the OS, makes things appear faster, dates clients, and spells out numbers. By Tom Kyte July/August 2006 I once read on your site that...

On Joins and Query Plans

  Our technologist optimizes joins and explains changing plans. By Tom Kyte May/June 2006   I know some of the rules about joins and that join 2 here is better than...

On Deduping and Ordering

  Our technologist deletes duplicates, gives trigger orders, and explains how SELECT locks. By Tom Kyte March/April 2006   Please help me write a SQL query that will...

On Sharing, Splitting, and Deleting

  Our technologist shares cursors, splits large tables, and deletes securely. By Tom Kyte January/February 2006   I am a bit puzzled by something you have said: "If...

On Transaction Isolation Levels

Our technologist isolates transactions safely. By Tom Kyte November/December 2005 Isolation Levels I've read the Oracle Database Concepts manual, Chapter 20, "Data...

My First Day with the New Release

  Our technologist talks about his first experience with Oracle Database 10g Release 2. By Tom Kyte September/October 2005   Can you tell us about your experience...

On Searching and Synonyms

  Our technologist searches, moves, and finds synonyms. By Tom Kyte July/August 2005   I want to create a new index, and I get the following error message:...

On Favorites and CONNECT BY

Our technologist picks, expands, loads, and dates. By Tom Kyte May/June 2005 What is your favorite Oracle Database feature, irrespective of version? This is...