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 ?
Oracle sequence is base on the number... not name.... etc.
You have to create sequence in sql workshop
CREATE SEQUENCE YOUR_NAME_OF_SEQUENCE;
Next if you will create some form in APEX you can use it as columne sequence (primary key)
I have to create a sequence so that when for example an employee is added using a form his ID will be saved based on his name, country, city, year he was created, month he was created and his number.
However, each employee is diff, so when you add another employee to the form his ID will be different, different name, country, city etc..
This has to be automatically generated.. is this possible?
Write your own function to create your custom sequence:
function get_next_my_own_sequence(name VARCHAR2, country VARCHAR2, city VARCHAR2, Year VARCHAR2, month VARCHAR2, Month VARCHAR2, NumberX VARCHAR2)
// Code to form your own sequence