Re: Number formatting question

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Sep 2006 06:38:28 -0700
Message-ID: <1157549905.440200@bubbleator.drizzle.com>

Ashish wrote:
> Hi,
>
> Sorry for asking such a dumb question.
> I have an alphanumeric key, the last 2 digits of which should increment
> every time a new record is saved.

What you have just described is a violation of basic data normalization. Alter your design or you will find yourself fighting this for the life of the system.

-- 
Daniel A. Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Wed Sep 06 2006 - 08:38:28 CDT