This content has been marked as final. Show 6 replies
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)
there isn't a way where we can create a sequence based on what i said?
I think, you have to more explain. Lets write again your problem in other words.
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
You have to create own function. In body you can qalculate checksum, fo example you can use md5 function. As parameters use you columns