Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Primary Key of type string ?

Re: Primary Key of type string ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 08 Jun 2007 08:39:24 -0700
Message-ID: <1181317162.983858@bubbleator.drizzle.com>


lrobins1_at_frontiernet.net wrote:
> Guys,
> I'm an MS SQL guy and wanted to verify something before I said
> anything (at work).
> If the only business requirement in an Oracle 10 db is that a BO (biz
> object) has a unique identifier, and this identifier is not created
> using data from said BO, would it ever make sense to use char data for
> this id field?

Yes.

But business rules should be established for such matters. What is the business rule? If you don't know ... have someone tell you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jun 08 2007 - 10:39:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US