Re: (aa) Datatype ROWID

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 11 Feb 1999 16:52:05 +0800
Message-ID: <36C29A35.31C3@bhp.com.au>

bob wuttke wrote:
>
> Please offer any CONS (or PROS) for the use of datatype ROWID for a
> column. thanks.

Depends on the application....ROWID's are great for "store-and-forward" messaging etc etc...

Example:

(A) trigger puts modified rowid's into message_table (B) message_table processor gets each rowid and gets full set of data from original table to send on to some other app/instance/server etc etc..

Message_table does not need to contain all the data in the original table, and access to the original table is lightning fast...

... don't forget if you unload/reload the data for your table, your rowid's may alter...

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Thu Feb 11 1999 - 02:52:05 CST