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 HTML DB, Bulking Up, and Speeding

Our technologist looks at Oracle Database 10g's HTML DB, building bulk, and improving speed. By Tom Kyte September/October 2003 I thought it might be fun for you...

On Procedures, Flushes, and Writes

Our expert compares triggers, procedures, flushing, and not flushing. By Tom Kyte July/August 2003 Suppose a piece of code can be implemented in either trigger or...

On Measuring Distance and Aging

  Our expert computes distance without aging and highlights favorite Oracle9i features. By Tom Kyte May/June 2003   I created a PL/SQL function to compute the...

On Partitions, Lookups, and Integrity

  Our expert partitions, looks up with a PL/SQL table, and does everything with referential integrity. By Tom Kyte March/April 2003   We would like to convert all...

On the Explicit, Size, and Complex

  Our technologist answers questions on cursors, extents, and intervals. By Tom Kyte January/February 2003   Is it true that from Oracle7 Release 7.3 onward,...

On Asking, Chaining, and Decoding

  Our technologist answers questions about questions, chained rows, and decoding. By Tom Kyte November/December 2002   How do you handle the questions on Ask Tom (ask...

Now Showing and Playing

  Our Oracle technologist shows how to use the unused index and how to play.   by Tom Kyte September/October 2002 I have a table called T that currently contains...

Parsing Densities, ANYDATA, and XML

  Our Oracle technologist looks at the hard parse, the soft parse, and the softer parse. By Tom Kyte July/August 2002   Can you explain the difference between a soft...

On Creating, Dating, and Binding

Our technologist creates XML, translates dates, and binds variables. By Tom Kyte May/June 2002 I want to create a file (a spool from a table) in an XML layout....