This discussion is archived
6 Replies Latest reply: Dec 22, 2012 6:37 AM by AndyPol RSS

How to create a sequence based on name, country, city, year, month, number

976941 Newbie
Currently Being Moderated
Hello,

I am using Application Express 4.2.1.00.08

I am new to apex and i need some help in creating a sequence.

I am creating an application where i profile people and i need to create an auto sequence that when the person is added to the database he will have his own sequence based on his name, country, city, year he was added, month he was added and his number.

This is a bit tricky because each person will have a different name, country city etc.

How can this be done ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points