Oracle

Tom Kyte, well known Oracle expert and Host of ‘AskTom.Oracle.Com’ shares his thoughts on Oracle Database 11g Release 2.

Link to the original site

The Tom Kyte Blog: http://asktom.oracle.com/tkyte/
Pointers to the material that was previously hosted on http://asktom.oracle.com/tkyte

SQL Profiles [PDF]
Paper about SQL Profiles by Christian Antognini

Articles & Presentations by Joel Goodman
A list of User Group presentations and articles that Joel wrote or co-authored and published in the past few years. Presentations were made to the UK Oracle User Group [...]

How Can I unload data to a flat file
Many times we are asked

“Does anyone know an easy way of dumping the data from an Oracle table into a delimited(comma, tab etc) ascii file?”
“Does anyone know an easy way to unload data in a format for sqlldr to reload later?”

Well here is a [...]

How Can I find out who called me or what my name is
Many times we are asked “in a procedure/function, can I find out who called me” or “can I dynamically figure out the name of the procedure or package that is currently executing”.
You can find it in the call stack returned by dbms_utility.format_call_stack. I [...]

Unindexed Foreign Keys
Having Unindexed foreign keys can be a performance issue. There are two issues associated with unindexed foreign keys. The first is the fact that a table lock will result if you update the parent records primary key (very very unusual) or if you delete the parent record and the child’s foreign key is [...]

Base Conversion Routines
This set of routines is useful to convert between various ‘bases’ in Oracle. Once you install these functions, you will be able to perform operations such as:
SQL> select to_bin( 123 ) bin, to_hex( 123 ) hex, to_oct( 123 ) oct from dual2 /

BIN [...]

UPDATE CASCADE PACKAGE

Generates needed package and triggers to support update cascadein Oracle without removing or infringing on DECLARITIVE RI.

This package supports:

Tables with multi-part primary keys (primary key(a,c,b))
Update cascade to many child tables from one parent
Self-referencing integrity such as that found in the SCOTT.EMP table(mgr->empno)

Is completely application transparent. The application does notknow it is happening
Versions [...]

This page will be published and republished over the next couple of days and into the future. It will contain pointers to the material that was previously hosted on http://asktom.oracle.com/tkyte. I’ll be reformatting those pages to fit into blogspot here and host the data supporting the pages in my “files” tab on asktom. [...]

For all events between now and the end of the year, my speaking schedule is published on asktom.oracle.com. This post hi-lights the “international” (for me, if you live there – it is local of course…) trips I’ll be doing. You can see all of the US only trips on asktom as well – [...]

For all events between now and the end of the year, my speaking schedule is published on asktom.oracle.com. This post hi-lights the “international” (for me, if you live there – it is local of course…) trips I’ll be doing. You can see all of the US only trips on asktom as well – [...]