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 Rollups, Merges, and Moves

Our technologist materializes, merges, and moves. By Tom Kyte March/April 2005 I have a parent table and a child table. The child table has a column 'qty'. I want...

On Injecting and Comparing

  Our technologist speaks on safe injections, comparing tables, and materialized views. By Tom Kyte January/February 2005   I was in the midst of reading your book Ef...

On Partitioning and Pipelining

  Our technologist speaks on UNION ALL, pipelines, and Saturdays. By Tom Kyte November/December 2004   I have a high-volume OLTP database in which I have partitioned...

On Fetching, Storing, and Indexing

Our technologist fetches sequentially, stores inline, and indexes globally. By Tom Kyte September/October 2004 We've got a problem concerning an ORA-01002 error in...

On Numbers and Analytics

  Our technologist searches, numbers, analyzes, and orders. By Tom Kyte July/August 2004   I have a control table that contains various values: numeric, character,...

On Sorts, Selecting, and Selectivity

  Our technologist looks at sorting, cursors, architecting, selecting, and extracting. By Tom Kyte May/June 2004   Can you provide an example of how to read from a...

On Format, Negation, and Sliding

  Our technologist modifies formats, makes zeros zeros, and avoids slides. By Tom Kyte March/April 2004   Formatting Dates and Times When I format a date, there are...

On Uniqueness, Space, and Numbers

Our technologist discusses determining space required, randomizing, and partition outer joins. By Tom Kyte January/February 2004 I'm looking for information on...

On Constraints, CASE, and Cursors

Our technologist talks integrity, time, and belonging. By Tom Kyte November/December 2003 After going through the Oracle9i Database Concepts Manual and your site,...