OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » HELP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HELP [message #41186]

Fri, 06 December 2002 05:02

Greg
Messages: 35
Registered: July 2000

Member

I want a primary key field on my form to automatically insert a registration number (e.g. IT01) following on from the last one updated to the database.

FOR EXAMPLE:
If I had 6 registration numbers already on the database the last one bieng (IT06) I want the next registration field to be IT07 which should appear in the registration field when a user inserts a new record.

Report message to a moderator

Re: HELP [message #41187 is a reply to message #41186]

Fri, 06 December 2002 07:16

B
Messages: 327
Registered: August 1999

Senior Member

Create a sequence
and create a trigger ...

Report message to a moderator

Previous Topic:	Matrix/Column transformation
Next Topic:	Concurrency in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 10:46:17 CDT 2024