Ask Tom (part of Oracle Magazine)

goto Oracle magazine and follow the Ask Tom link to see questions and answers or submit a question yourself.

Also, here is a link: to all of the print articles that have been published in Oracle Magazine to date...

IDeveloper Articles by Thomas Kyte

May 1999 - Function Based Indexes
June 1999 - Fine Grained Access Control (aka DBMS_RLS)
June 1999 - Part I of V, Autonomous Transactions

Selected Utilities/Frequently Asked Questions

Update Cascade
Base Conversion Functions (hex to decimal, generic base conversions)
Unindexed Foreign Keys -- why they might be bad and how to detect them
Who Called Me -- within PL/SQL find out who called you
Makefile for unix Pro*C that works with v7-v8
WebAlchemy - freeware to convert HTML into stored procedures
Unloader - unload data from Oracle into a flat file or into a file suitable for sqlldr to reload
Getting Result Sets from Stored Procedures (HOWTO)
Avoiding Mutating Tables (HOWTO)
Skipping Columns with SQLLDR (HOWTO)
Getting the difference between 2 dates (HOWTO)
Inserting Large Character Strings (HOWTO)
Moving Long Columns from Table to Table/Database to Database (HOWTO)
Why doesn't my init.ora parameter NLS_DATE_FORMAT seem to work
Why do I get an ORA-1031 or PL-201 with stored procedures
Spelling a number (HOWTO)
Can I become another user (HOWTO)
OCI N-Tier Authentication (HOWTO)
Convert Between the UNIX time_t and Oracle date type (HOWTO)
Random Numbers in PLSQL (HOWTO)
Creating a delimited file in PLSQL with UTL_FILE (HOWTO)
How to store passwords for your app in the Database (HOWTO)
How to build a simple test harness (RUNSTATS) (HOWTO) to test two different approaches from a performance perspective
How to print down the page in plus (HOWTO) to get output going DOWN instead of ACROSS in sqlplus...
debug.f (HOWTO) Simple debugging routine to create trace files from your applications in plsql
free.html (HOWTO) Report database free space by tablespace

Some online presentations

These have moved to the Files tab on the home page of Asktom All information and materials provided here are provided "as-is"; Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use of this information or these materials.