Finding the Next Primary Key Value, a Pre-fixed Solution

(Charles Hooper) A request for assistance came in from an ERP mailing list. The original poster (OP) is running an unspecified version of Oracle Database 9i, and is in need of a solution to generate new part numbers with prefixed characters that describe the type of part, followed by a sequential n

Read More - Register for Free Membership