Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: GUID as primary key
sybrandb_at_yahoo.com schrieb am 20.06.2005 in
<1119280748.220119.213400_at_f14g2000cwb.googlegroups.com>:
> Andreas Mosmann wrote:
>>> Andreas, Billy provided the necessary statement, but what is the point >>> of adding a GUID to every table? Does every table really need a GUID?
>>> Just curious -- MArk D Powell --
> A guid being a RAW and many applications treating the RAW as a VARCHAR2 > using implicit conversion, skipping indexes, there is every chance it > won't help at all and make your life miserable.
We decided to handle this explicit as a string seperated in the format
NET generates. To adapt the Oracle-key is simple and so you will not
find a difference in handling the data.
An advantage (in our opinion) is, that every part of program can create
a new record, does not matter whether it is a PL/SQL- Trigger or a .NET-
Program, even without any database- connection.
> Please reconsider.
I hope we do not have to, because we already went too far.
> -- > Sybrand Bakker > Senior Oracle DBA
-- wenn email, dann AndreasMosmann <bei> web <punkt> deReceived on Mon Jun 20 2005 - 10:55:23 CDT