Re: HOW? Sequencing primary key appended with a character.

Hilary Juma wrote:
>
> Please how can one sequence the primary key each time to create a tuple.
>
> Examples
> supplier# value is S1001
> the next should automatically be s1002 on creation.

  Use sequence in Oracle. Whenever you insert a new record, just fetch nextval from the sequence.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841